Excel: Splitting First and Last Names in a Cell into Two Separate Cells

thank you all the way from the future

Thank you very much for this video!! I have a question please, how can I separate the names if they have a minus symbol (-) in between? Example: John-Smith
Thank you so much!!

why cant it just go until theres a space instead of doing the number of characters

thanks

Nice work

thanks

Do you have excel 2028? My time machine broke down and I want to organize my targets in excel.

Thank you sooo much sir for helping me out ....

got it

nope. Doesn't work

Awesome

You lost me when you input the space

Perfect Instruction!

Is there a way to separate text by underscores and organize each into columns? such as variable_name_location_date

mine refuses to work, i have followed step by step and excel just will not pull the data
PLEASE HELP

how can i split this? example: MarvinRiggs, no space in first & last name, but how cab i split those, plz help me out

Thank you so much, you just saved me. I needed to have this done by a 10 am meeting.

You have helped me out lots...15000 names to separate as we have a new system in place and I was literally about to pull my hair out if I had to do it all one by one!

Very much useful Technic

Wonderful tutorial. Thank you.