View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
pjy pjy is offline
external usenet poster
 
Posts: 14
Default Data within a cell

You could always split the cell into 3 columns by going to Data, then text to
columns and adjust that way as well.

"David" wrote:

If names are in cells as "last name, first name, middle initial" can a macro
be run to change the order to "first name, middle initial, last name"?