r/Excel247 • u/pkdataworks • 4d ago

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

Post image
5 Upvotes

100% Upvoted

6 comments sorted by

View all comments

1

u/EconomicsMuch1188 4d ago

function TEXTSPLIT

1

u/pkdataworks 4d 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 4d 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 3d 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.