Flipping order of contents of a cell based on a coma

[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.

 

[T. Valko]

Try this:

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

Copy down as needed.

Biff

 

[chunt]

Awesome, Thanks

Try this:

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

Copy down as needed.

Biff

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

Awesome, Thanks