Flipping order of contents of a cell based on a coma

  • Thread starter Thread starter chunt
  • Start date Start date
C

chunt

I have the following information in a column:

VIGNEAULT, NATALIE A
RYAN, BRANDON D
HALLEY, ANDREA S
SCOTT, BRIAN L
SEBHATU, LUWAM
GOMES, MARIA L
NABIGON, JOHN E
COLE, CHARLOTTE A


I need to flip the contents around so that VIGNEAULT, NATALIE A would
become NATALIE A VIGNEAULT (without the coma).

Any ideas would be greatly appreciated!

Thanks,
Chris.
 
Try this:

=MID(A1&" "&A1,FIND(",",A1)+2,LEN(A1)-1)

Copy down as needed.

Biff
 
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

how to flip contents inside the cell of an excel? 2
how do you flip the order of the content in a cell. 2
How do I reverse the row order in Excel, not based on content? 2
autopopulate based on a cell value 2
Delete contents of cells in a range based on value of a cell 2
conditional format of entire row based on a single cell in row 7
Finding the Row number based on contents of a cell 5
sum values in cell based on another cell 2

Back
Top