Excel Magic Trick #8: Text To Column
Loading...
31,114
Loading...
Uploader Comments (ExcelIsFun)
see all
All Comments (16)
-
its really fun..
-
great help, thanks!
-
Thanks for trick
Loading...
I Found this Video very Helpful!! Thanks...
MrRavuthOum 9 months ago
I am glad that the video helped!
ExcelIsFun 9 months ago
nice, there is a little detail that i want you to explain why it happens
considering the space (or any other) as a separation character, excel will always delete this character. why is that? my situation is that excel deletes the entire word that follows the separation character and that is frustrating
domus300 1 year ago
I do not know. Try posting to THE best Excel question site:
mrexcel[dot]com/forum
ExcelIsFun 1 year ago
so how do you do the opposite? you have 2 columns but you want to merge them into one.
redrising9815 1 year ago
Try the next trick:
Excel Magic Trick # 9: Join 2 Cells into 1
Let me know if that accomplishes your goal.
ExcelIsFun 1 year ago