Field Format

[N Sabo]

I have a column of name data in the format of "First Name Last Name". Does
anyone have a script that will change all the entries in this column to
"Last Name, First Name" ?

 

[mudraker]

suggest copy name list to a blank workbook follow the steps then paste
name list back into original list

One option without using a macro is to parse the text to column using
space as the delimiter then use a formula ro recombine them in the
format required then copy formulas & special paste values

example

cell a1 entry equals LastName Firstname

pased data becoms

b1 entry Lastnmae
c1 entry Firstname


formula in d1
=d1 & " " & c1

copy d1 & paste special value into e1

decopy e1 and paste into original sheet

 

[Gord Dibben]

Have a look at Chip Pearson's First/Last page.

http://www.cpearson.com/excel/FirstLast.htm

Gord Dibben Excel MVP