Flipping order of contents of a cell based on a coma

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chunt@vvsii.com - 16 Jan 2007 19:20 GMT

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.

Reply to this Message

T. Valko - 16 Jan 2007 19:36 GMT

Try this:

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

Copy down as needed.

Biff

>I have the following information in a column:
>
[quoted text clipped - 14 lines]
> Thanks,
> Chris.

Reply to this Message

chunt@vvsii.com - 16 Jan 2007 20:13 GMT

Awesome, Thanks :)

> Try this:
>
[quoted text clipped - 22 lines]
> > Thanks,
> > Chris.

Reply to this Message

T. Valko - 16 Jan 2007 20:55 GMT

You're welcome. Thanks for the feedback!

Biff

> Awesome, Thanks :)
>
[quoted text clipped - 24 lines]
>> > Thanks,
>> > Chris.

Reply to this Message

Rate this thread: