Text to Columns an Excel Worksheet

[karizze_fitzgeraldine]

Hi,

I'm trying to apply 'Text to Columns' to the attached worksheet but cannot seem to do so since it's not a csv file. Anything else that I can do?

Thank you!

[binuacs]

@karizze_fitzgeraldine This is working for me. Can you try again?

[karizze_fitzgeraldine]

Thank you, but how do I keep the header? sorry was not specific enough!

[Emmanuel_G]

Hi @karizze_fitzgeraldine ,

Find attached the way of doing this.

Please do not hesitate to mark this answer as solution if it helped.

[Qiu · Accepted solution]

@karizze_fitzgeraldine 

I am thinking a more dynamic way, since the number of your columns might change.

The sample below should be adaptive.

[binuacs · Accepted solution]

@karizze_fitzgeraldine Updated the workflow##

[karizze_fitzgeraldine]

Thank you all! This is resolved! :) 

[binuacs]

@karizze_fitzgeraldine Good to know it was resolved.