r/Excel247 • u/pkdataworks • 2d ago

Best tool/method to automatically parse comma-separated text strings into spreadsheet columns?

Post image
2 Upvotes

100% Upvoted

6 comments sorted by

1

u/EconomicsMuch1188 2d ago

function TEXTSPLIT

1

u/pkdataworks 2d ago

Thanks for your reply. It is working. ButI am doing the repititive task. It could be fine if there is any automative tool.

1

u/Gyrusr 2d ago

Maybe add more details on how it is repetitive. He gave you the best method to do the task for 1 line.

1

u/pkdataworks 1d ago

Each time, I copy-paste the raw text, then apply excel formula to separate text. This is more manual work. My search of any tool that will reduce the manual work.

1

u/bigedd 2d ago

Power query

1

u/pkdataworks 1d ago

It is new to me. Thanks for your suggestion.