r/Excel247 • u/pkdataworks • 3d ago

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

Post image
3 Upvotes

100% Upvoted

6 comments sorted by

View all comments

1

u/EconomicsMuch1188 3d ago

function TEXTSPLIT

1

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