Split Text to Columns in Google Sheets (separate first and last name)

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Google Sheets topics you want me to cover in future videos.

Outdated :(

Thank you. This was a huge time saver! Had no idea.

Thanks!

I can't seem to get it to work with a tab delimiter

Thanks for the video 🤠

This is the best solution I found. So simple. Thank you !

Thanks, I found this video helpful as it helped me segregate my data.

What if the data is separated in a cell by a line break?

Thanks a lot! 😇😇

Amazing!!!

Hi Admin,

What to do if you have 3 words in the name like DR. Abc Xyz?

amazing! Thank you.

thank you!! Can you do a video on how to split info in one cell to rows? I have information separated by comma.

Thank you!! You're a lifesaver!!

Thank you for this instructive, easy to digest video. May God bless you.

BUT Harry Potter isnt superhero!

THANK YOU SOOO MUCH !

Thank you

I don't want to keep hitting that button... Is there a way to fix this?
Great Video

I use this all the time, it is awesome.

You're a lifesaver!!!!

Thank You. This was helpful.

Help! I'm not seeing the "separator" floating pane after clicking on the menu item. It just splits with some default separator. Any ideas why this could be happening? Thanks