Question description:
This user has given permission to use the problem statement for this
blog.
What is the formula for splitting up one column text into 2 columns?
Solved by B. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
16/05/2018 - 05:54
Hi…Welcome to Got It Pro
User
16/05/2018 - 05:54
thx
Excelchat Expert
16/05/2018 - 05:55
Could you show a sample of your text data in this blank sheet?
User
16/05/2018 - 05:56
how's that
Excelchat Expert
16/05/2018 - 05:56
So you want it separated into 3 columns?
User
16/05/2018 - 05:56
yes please
Excelchat Expert
16/05/2018 - 05:56
sure...let me give you the formula
User
16/05/2018 - 05:57
ok, thank you.
User
16/05/2018 - 05:58
Just show me when you are ready. thank you.
Excelchat Expert
16/05/2018 - 05:58
I am doing the formula on this sheet
Excelchat Expert
16/05/2018 - 06:00
ok..I have put the formulas in C2, D2 and E2
Excelchat Expert
16/05/2018 - 06:01
These are string manipulation formulas like LEFT, RIGHT, Substitute
Excelchat Expert
16/05/2018 - 06:01
Does that solve your query?
User
16/05/2018 - 06:03
It was more complicated than I thought, so thank you for answering.
Excelchat Expert
16/05/2018 - 06:03
Is there anything else I can help you with this query?
Excelchat Expert
16/05/2018 - 06:08
Please do give me a good feedback for my service.
Excelchat Expert
16/05/2018 - 06:08
Thanks for your time. Please do come back for any new question. Have a great day ahead!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.