| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Text Format from LAST NAME, First Name to First Name La
I have imported data from another program and all of the names are in this
format: Last Name, First Name How can I change to First Name Last Name??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Text Format from LAST NAME, First Name to First Name La
You can use this to swap names around:
=MID(A2,FIND(",",A2)+2,256)&" "&LEFT(A2,FIND(",",A2)-1) Then copy, paste special- values. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Tina" wrote: I have imported data from another program and all of the names are in this format: Last Name, First Name How can I change to First Name Last Name??? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Text Format from LAST NAME, First Name to First Name La
With
A1: The Clown, Bozo This formula converts that text to FirstName LastName B1: =TRIM(MID(A1&" "&A1,FIND(",",A1&" "&A1)+1,LEN(A1))) Is that something you can work with? Regards, Ron Coderre Microsoft MVP (Excel) "Tina" wrote in message ... I have imported data from another program and all of the names are in this format: Last Name, First Name How can I change to First Name Last Name??? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Text Format from LAST NAME, First Name to First Name La
Actually made that formula more complicated than it needed to be.
Try this: B1: =TRIM(MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1))) Does that help? Regards, Ron Coderre Microsoft MVP (Excel) "Ron Coderre" wrote in message ... With A1: The Clown, Bozo This formula converts that text to FirstName LastName B1: =TRIM(MID(A1&" "&A1,FIND(",",A1&" "&A1)+1,LEN(A1))) Is that something you can work with? Regards, Ron Coderre Microsoft MVP (Excel) "Tina" wrote in message ... I have imported data from another program and all of the names are in this format: Last Name, First Name How can I change to First Name Last Name??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting date into text format | Excel Discussion (Misc queries) | |||
| Converting DD/MM/YYYY format into text MMYYYY | Excel Discussion (Misc queries) | |||
| Converting Text to Time format of XX:XX | Excel Discussion (Misc queries) | |||
| Converting number or text to a Date Format | New Users to Excel | |||
| Keep number format after converting time to text | Excel Discussion (Misc queries) | |||
Linear Mode
