If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




Flipping a last name comma first name in the same cell
Hello ...
Does anyone know how to flip last name and first name e.g. Robinson, Tina to Tina Robinson in the same cell  Thanks!! T. Marie 
Ads 
#2




Flipping a last name comma first name in the same cell
Hi,
If it must be in the same cell then that's a macro so post back but if an adjacent cell will do try this for a name in a1 =MID(A1,SEARCH(" ",A1)+1,LEN(A1))&" "&LEFT(A1,SEARCH(",",A1)1) Mike "Tina Marie" wrote: > Hello ... > > Does anyone know how to flip last name and first name > > e.g. Robinson, Tina to Tina Robinson in the same cell > > >  > Thanks!! > > T. Marie 
#3




Flipping a last name comma first name in the same cell
Tina Marie,
Then you could copy from the results of the formula Mike H provided, and paste special as values into the original cell, then delete the formula. HTH, Conan "Mike H" > wrote in message ... > Hi, > > If it must be in the same cell then that's a macro so post back but if an > adjacent cell will do try this for a name in a1 > > =MID(A1,SEARCH(" ",A1)+1,LEN(A1))&" "&LEFT(A1,SEARCH(",",A1)1) > > Mike > > "Tina Marie" wrote: > >> Hello ... >> >> Does anyone know how to flip last name and first name >> >> e.g. Robinson, Tina to Tina Robinson in the same cell >> >> >>  >> Thanks!! >> >> T. Marie 
#4




Flipping Names in same cell
=&RIGHT(C3,LEN(C3)FIND(",",C3,1))&" " &LEFT(C3,FIND(",",C3,1)1)&
Where C3 is the cell with the name formatted as Smith, John 
#5




Flipping Names in same cell
Sub flipnameinsamecell()
For Each c In range("a2:a22")'Selection x = InStr(c, ",") c.Value = Right(c, Len(c)  x) & " " & Left(c, x  1) Next c End Sub  Don Guillett Microsoft MVP Excel SalesAid Software "Raymie Younkin" wrote in message ... > =&RIGHT(C3,LEN(C3)FIND(",",C3,1))&" " &LEFT(C3,FIND(",",C3,1)1)& > > Where C3 is the cell with the name formatted as > > Smith, John 
#6




Question about Flipping Names in same cell
say i have John Smith in A1 and want it to be Smith John in A2, what would the formula look like that would be in A2?
thank you!!! 
#7




Question about Flipping Names in same cell
Hi
This will not work if A1 contains a middlename. =RIGHT(A1,SEARCH(" ",A1)) & " " & LEFT(A1,SEARCH(" ",A1)1) Regards, Per "Catherine Damiani" skrev i meddelelsen ... > say i have John Smith in A1 and want it to be Smith John in A2, what would > the formula look like that would be in A2? > > thank you!!! 
#8




Question about Flipping Names in same cell
Hi,
If there is no middle name, then select column A and then Data > Text to columns. While on delimited, click next and on the next screen, uncheck all boxes except spaces. Click on finish. Now in a spare column, enter B1&" "&A1  Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Catherine Damiani" wrote in message ... > say i have John Smith in A1 and want it to be Smith John in A2, what would > the formula look like that would be in A2? > > thank you!!! 
#9




Question about Flipping Names in same cell
This will work as long as there is no middle initial or middle name and as
long as the first name is never made up of two names (such as Mary Anne)... =MID(A1&" "&A1,FIND(" ",A1)+1,LEN(A1))  Rick (MVP  Excel) "Catherine Damiani" wrote in message ... > say i have John Smith in A1 and want it to be Smith John in A2, what would > the formula look like that would be in A2? > > thank you!!! 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Flipping text  Charlene  Excel Worksheet Functions  4  November 15th 07 05:49 PM 
Flipping a Spreadsheet  Joy  Excel Worksheet Functions  1  July 18th 07 02:16 PM 
flipping a spreadsheet  remarque  Excel Worksheet Functions  2  October 27th 06 01:55 PM 
Data Flipping  alamsemu  Excel Discussion (Misc queries)  1  March 10th 05 06:56 AM 
Flipping the order around?  thrava  Excel Discussion (Misc queries)  4  January 14th 05 02:23 PM 