Name Format
 

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".

One way:
Assuming your list is in column A Highlight the list DataText to
ColumnsDelimited
Other and enter a spaceDestinationB1
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
"NH" wrote:

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".

NH Wrote:
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".

Hi NH

Try this select the cell/s with the names in, then Data Text to
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 will
put first name, initial and last name in separate cells

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


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=474784