Name Format

N

NH

Is it a way to change a name format from "First_ name Middle_ Initial,
Last_name" to "Last_name, First_name Middle_initial"? For example, from
"John A. Smith" to "Smith, John A".
 
R

Ray A

One way:
Assuming your list is in column A Highlight the list Data>Text to
Columns>Delimited>
Other and enter a space>Destination>B1
Now you have seperated the names into 3 parts In cell E1 enter ,
Now the formula in F1is =D1&$E$1&" "&B1&" "&C1
Copy the formula down
HTH
 
P

Paul Sheppard

NH said:
Is it a way to change a name format from "First_ name Middle_ Initial,
Last_name" to "Last_name, First_name Middle_initial"? For example
from
"John A. Smith" to "Smith, John A".
Click to expand...

Hi NH

Try this > select the cell/s with the names in, then > Data > Text t
Columns > select the Original data type as delimited > click next
under delimiters click space > the preview should show the first name
initial and last name in different columns > click finish, this wil
put first name, initial and last name in separate cells

Next in column D enter this formula > =CONCATENATE(C1,", ",A1," ",B1)
copy down as require
 
Top