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
|