LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
 
Posts: n/a
Default change first-name-last to last-name-first in a single cell?

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change event on specific cell rather than worksheet frendabrenda1 Excel Discussion (Misc queries) 10 September 21st 06 03:37 AM
How can a single cell be incremented? i.e. N=N+1 Remel Excel Discussion (Misc queries) 1 September 21st 05 08:19 PM
change info in 1 cell, prompts you for another redb Excel Discussion (Misc queries) 2 September 1st 05 11:56 AM
Help creating single cell Pop-up Bill Excel Worksheet Functions 2 June 23rd 05 05:21 PM
Change cell color dependin on date ... T. Denford Excel Worksheet Functions 4 April 13th 05 01:59 AM


All times are GMT +1. The time now is 10:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"