Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Last Name, First Name extract
Column A has names in it. The format is Last Name, Space First Name. How do I
extract the names so they appear in the same column or another column in this format. First Name space Last Name. Thank You in advance. Tony |
#2
|
|||
|
|||
If exactly as described
=MID(A1,FIND(", ",A1)+2,99)&" "&LEFT(A1,FIND(", ",A1)-1) -- HTH Bob Phillips "Tony" wrote in message ... Column A has names in it. The format is Last Name, Space First Name. How do I extract the names so they appear in the same column or another column in this format. First Name space Last Name. Thank You in advance. Tony |
#3
|
|||
|
|||
Thanks Bob,
It worked fine, exactly what I needed. "Bob Phillips" wrote: If exactly as described =MID(A1,FIND(", ",A1)+2,99)&" "&LEFT(A1,FIND(", ",A1)-1) -- HTH Bob Phillips "Tony" wrote in message ... Column A has names in it. The format is Last Name, Space First Name. How do I extract the names so they appear in the same column or another column in this format. First Name space Last Name. Thank You in advance. Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract Command in Excel 1 | Excel Discussion (Misc queries) | |||
Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) | |||
extract data from cells | Excel Worksheet Functions | |||
Extract text | Excel Worksheet Functions | |||
Extract Pixel Values to Excel? | Excel Worksheet Functions |