Convert string in format "Smith, John" to "John Smith"

**ks100** · 09-03-2015, 10:33 AM

I pull in usernames in the form of "Smith, John" into a string.

I would like to convert this string to be "John Smith" instead.

What's an easy way to do this?

Thanks!

**TMS** · 09-03-2015, 12:00 PM

You can do that fairly easily with a formula. However, i suspect that not all of your data will be that simple to parse.

Please post a sample workbook with some typical data ... or just a list of possibilities would do.

Regards, TMS

**stnkynts** · 09-03-2015, 12:05 PM

Something like this:

Please Login or Register  to view this content.

Convert string in format "Smith, John" to "John Smith"

LinkBack

Thread Tools

Rate This Thread

Display

Convert string in format "Smith, John" to "John Smith"

Re: Convert string in format "Smith, John" to "John Smith"

Re: Convert string in format "Smith, John" to "John Smith"

Thread Information

Users Browsing this Thread

Similar Threads

Need to combine single names with the same address into "John and Jane" Smith

How do I isolate the date from: "John M Smith 02-22-1965 (M)" - my ideas are not working

[SOLVED] COUNTIF COLUMN F="John Smith" AND COLUMN AE = TRUE ?

Single Column String to email formula "smith, john" to [email protected]

Single Column String to email formula "smith, john" to [email protected]

[SOLVED] Change Smith, John to John Smith

Replace text "Smith, Joe" into "Joe Smith" for a single cell

Bookmarks

Bookmarks

Posting Permissions