We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

Swap Firstname & Lastname


jaraba
Resolved

Likes # 0

I have spreadsheet which has names in one column as "Smith John" and I want to transfer them to another 2 columns with Firstname in one & lastname in the other.

Any advice on a formula to do this would be much appreciated.

I know I can do this by using text to columns but the info is pasted in from another program and I need it to be swaped automatically.

Like this post
Fruit Bat /\0/\

Likes # 0

Right(text, number of characters) function returns number of character of text starting from right. Example: Right(“Blogs Fred”, 4) will return Blogs as a result

Left(Text, number of characters) function returns number of characters of text starting from left. Example: Left(“Blogs Fred”, 5) will return Fred as a result

Length on any text can be determine using LEN(text) function.Example : Len(“Blogs Fred”) will return 10 as a result.

To find position of space in the text which can be done using Find(what to find, from where) function. Example : Find(“ “, ““Blogs Fred””) will return 6.

Formula: =RIGHT(A3,LEN(A3)-FIND(" ",A3))&" "&LEFT(A3,FIND(" ",A3)-1) will reverse the two words in A3

Like this post  
jaraba

Likes # 0

*Fruit Bat /\0/*

Many thanks

Will mark as resolved.

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

Galaxy S6 UK release date, price, specs: When is the Samsung Galaxy S6 coming out? Galaxy S6 launch6......

IDG UK Sites

5 things we hate about MWC: What it's like to be a journalist at a technology trade show

IDG UK Sites

Interview: Lauren Currie aims to help design students bridge skills gap

IDG UK Sites

12in Retina MacBook Air release date rumours: new MacBook Air to have fingerprint ID, could launch...