Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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". |
#2
|
|||
|
|||
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". |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
why does currency format change to number format? | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) |