Arranging Text in Columns

**shawnna** · 08-29-2017, 02:37 PM

I need help creating a formula for the following:

Original:
Doe, Jane - 456320

Output should be:
456320 - Doe, Jane

Please help!

**davesexcel** · 08-29-2017, 03:35 PM

Possibly,

Please Login or Register  to view this content.

Ah!!!, I forgot to c1 has the formula

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

**AlKey** · 08-29-2017, 03:36 PM

Try this

Formula:

Please Login or Register  to view this content.

v	A	B
1	Doe, Jane - 456320	456320 - Doe, Jane

**shawnna** · 08-29-2017, 03:55 PM

Thank you, it WORKED!!!

Re: Arranging Text in Columns