View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default reverse text based on a character

The following formula will extract and concatenate the data for you:

=RIGHT(A1,LEN(A1)-FIND(",",A1,1)-1)&", "&LEFT(A1,(FIND(",",A1,1)-1))

Changing A1 to match the cell that contains the name.
--
Kevin Backmann


"george" wrote:

i want to change a cell that contains: First name, last name to read last
name, First name