change first-name-last to last-name-first in a single cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet with 1,000 names and addresses. I would like to re-order
the names (which are all in single full-name cells) from first-name last-name
order to last-name first-name order.
When I try to run a macro selecting relative cells, it attempts to paste
name from example cell into all other cells.
 
Do you mean this

Ron de Bruin (in cell B2) will be Bruin, Ron de

=IF(ISERR(FIND(" ",B2)),IF(LEN(B2)=0,"",B2),MID(B2,FIND("^^",SUBSTITUTE(B2," ","^^",LEN(B2)-LEN(SUBSTITUTE(B2," ",""))))+1,1024)&",
"&LEFT(SUBSTITUTE(B2," ","^^",LEN(B2)-LEN(SUBSTITUTE(B2," ",""))),FIND("^^",SUBSTITUTE(B2," ","^^",LEN(B2)-LEN(SUBSTITUTE(B2,"
",""))))-1))

This is a option in the DataRefiner add-in
http://www.rondebruin.nl/datarefiner.htm
 
I would just use Data > TextToColumns > SpaceDelimited, to separate the names
into two columns and then use CONCATINATION to put them back together the way
I wanted them..........if you choose to do it this way and need assistance,
post back and someone will help

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First, Last occurance of date in column 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
VBA - retrieve data on last create named range from previous inserted named range 0
ALPHABETIZING! 2
First Name & Last Name 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Separate first name, middle name and last name 2
Pulling only first name 3

Back
Top