Swap Firstname & Lastname

  jaraba 21:45 22 Mar 2012

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.

  Fruit Bat /\0/\ 22:40 22 Mar 2012

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

  jaraba 07:47 23 Mar 2012

*Fruit Bat /\0/*

Many thanks

Will mark as resolved.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iPhone X review

How to find a font: Discover the name of a typeface with these apps

The best iPhone for 2017

Comment créer un compte PayPal pour payer en ligne ?