All,
Any easy way to convert Smith John to Smith,John? No need to lose the space.
I tried a find and replace but some people have middle names like Smith John C so it ends up replacing it to look like Smith,John,C
Thanks!
All,
Any easy way to convert Smith John to Smith,John? No need to lose the space.
I tried a find and replace but some people have middle names like Smith John C so it ends up replacing it to look like Smith,John,C
Thanks!
Try
=SUBSTITUE(A1," ",",",1)
That was crazy easy. Def a function i didnt know. Thanks!
Try this out:
=SUBSTITUTE(TRIM(A1)," ",",")
If there are any additional spaces, present accidetally, this will prevent the extra ones from beoming commas.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
In another cell
=SUBSTITUTE(A1, " ",", ",1)
copied down.
Then copy new column and paste special Values back into the original column (Col A for example)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
You're welcome..
Keep in mind, it will be wrong for people with 2 word last names like Van Pelt or whatever..
And there really isn't anything you can do about it
Considering that Either the first or last name could have 2 words.
There is no way for excel to know if it's the first or last name (or both) that is 2 words.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks