Excel Magic Trick #8: Text To Column

[carrentalsg]

its really fun..

[IviEspinosa]

great help, thanks!

[kjohnson0078]

Thanks for trick

[MrRavuthOum]

I Found this Video very Helpful!! Thanks...

[ExcelIsFun]

I am glad that the video helped!

[domus300]

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

[ExcelIsFun]

I do not know. Try posting to THE best Excel question site:

mrexcel[dot]com/forum

[redrising9815]

so how do you do the opposite? you have 2 columns but you want to merge them into one.

[ExcelIsFun]

Try the next trick:

Excel Magic Trick # 9: Join 2 Cells into 1

Let me know if that accomplishes your goal.

[blueangel0510]

looks like the answer to my question is in the trick #9 lol

[ExcelIsFun]

Laugh out loud, it helps when you are doing Excel!

[blueangel0510]

But I do have a question? What if i do not want to separate them into to columns. What if i i just want to interchange the position of the first name and the last name?

[ExcelIsFun]

To switch first and last names, I have a few videos about this.

Find this playlist, which has them all:

Various Excel Separate Text (like First Last Names) Tricks

or this video title:

Excel Magic Trick 292: Reverse Last & First Name Tricks

But really, the playlist is the place to go becasue it has various videos for whatever trick you might want to do.

[blueangel0510]

I was always doing copy paste just to separate names and lastnames thanks to your video I now know what to do!

[ExcelIsFun]

I am glad that it helps!

It looks like you are watching the Magic tricks from #1 forward. That is good, but if you want to learn how to find the exact video you want, search for and watch this video title (it shows how to search and find Playlists):

Search For Excel Videos Download Excel Files excelisfun

Also, if you want to learn Excel from beginning to end watch the playlists:

Excel Basics Series

then go to

Highline Excel Class Series

[shiryu008]

great!

[periwink]

5 :)

[ExcelIsFun]

Dear periwink ,

:)

--ExcelIsFun

[ExcelIsFun]

Dear fastandfaster,

No problem. I'll keep making videos if you keep watching and rating!

--ExcelIsFun