NEED EXCEL FORMULA

[Kathrynlewis]

I am compiling a contact list with contact name, company name, address, phone number etc. I want to make the zip code two columns. Column A with the first portion and column B with the last 4 numbers. I have been given a spreadsheet with the zip code in one column. As follows.
What I currently have:

Column A
902100000
987250000
601515821

What I want:
Column A Column B
90210 0000
98725 0000
60151 5821

 

[xlbo]

=TEXT(Left(A1,4),"0&quot
=TEXT(Right(A1,4),"0&quot
should do the trick

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[SkipVought]

HI,
You can also use the Text to Columns Wizard...

1. Select the column that has the phone data
2. Menu item Data/Text to Columns.../
3. Select the Fixed Width option button and Next
4. Add line breaks at the appropriate positons and Next
5. Select TEXT column format for each grouping in the Data preview window and Finish.

... and VOLA!

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com