software

Thank you all for earlier help. I am now parsing a column of 15,427
records containing combined State and Zip Code data, IE:

A
1 NY 10023

And I need to parse that data into two separate columns.

I was using the Macro funtion earlier for some successful endeavors,
but the tiny Macro Toolbar quot;Stop Recording / Referencequot; has
disappeared.

1) Can anyone help me with the trick to that bloody toolbar, and
2) Is a Macro the best way to accomplish such a parsing...

(With one empty new column to the right, I was going to go into cell
edit mode, Cut the Zip, delete the three spaces to the R of the State,
Paste the Zip in the new Column to the right, and decend one Row... or
something to that effect).

Thank you so much, folks.--
jawdawson
------------------------------------------------------------------------
jawdawson's Profile: www.excelforum.com/member.php...oamp;userid=30648
View this thread: www.excelforum.com/showthread...hreadid=503121Put the following formula in the column B amp; C, they will provide u the
state in the column B amp; zip in the column without any spaces
B C
=TRIM(LEFT(A1,2)) amp; =TRIM(RIGHT(A1,5))
NY 10023

Hope the above solution will help u.

---
Selvarathinam.How about using Datagt;Text to Columnsgt;Delimited by space?Gord Dibben MS Excel MVP

On Thu, 19 Jan 2006 17:07:30 -0600, jawdawson
gt; wrote:

gt;
gt;Thank you all for earlier help. I am now parsing a column of 15,427
gt;records containing combined State and Zip Code data, IE:
gt;
gt;A
gt;1 NY 10023
gt;
gt;And I need to parse that data into two separate columns.
gt;
gt;I was using the Macro funtion earlier for some successful endeavors,
gt;but the tiny Macro Toolbar quot;Stop Recording / Referencequot; has
gt;disappeared.
gt;
gt;1) Can anyone help me with the trick to that bloody toolbar, and
gt;2) Is a Macro the best way to accomplish such a parsing...
gt;
gt;(With one empty new column to the right, I was going to go into cell
gt;edit mode, Cut the Zip, delete the three spaces to the R of the State,
gt;Paste the Zip in the new Column to the right, and decend one Row... or
gt;something to that effect).
gt;
gt;Thank you so much, folks.
Both suggestions helpful - thank you. Text to Columns was magic. Thank
you both.--
jawdawson
------------------------------------------------------------------------
jawdawson's Profile: www.excelforum.com/member.php...oamp;userid=30648
View this thread: www.excelforum.com/showthread...hreadid=503121If you use Data, Text to columns
be sure to specify within the Text to columns
that the second column is text. Formatting the
column as text beforehand is not good enough.

Many east coast zip codes have a leading zero.
---quot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote ...
gt; How about using Datagt;Text to Columnsgt;Delimited by space?
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Thu, 19 Jan 2006 17:07:30 -0600, jawdawson
gt; gt; wrote:
gt; gt;1 NY 10023
gt; gt;
gt; gt;And I need to parse that data into two separate columns.
Good point David.

Thanks, Gord

On Fri, 20 Jan 2006 11:38:46 -0500, quot;David McRitchiequot;
gt; wrote:

gt;If you use Data, Text to columns
gt;be sure to specify within the Text to columns
gt;that the second column is text. Formatting the
gt;column as text beforehand is not good enough.
gt;
gt;Many east coast zip codes have a leading zero.
gt;---
gt;
gt;
gt;quot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote ...
gt;gt; How about using Datagt;Text to Columnsgt;Delimited by space?
gt;gt;
gt;gt;
gt;gt; Gord Dibben MS Excel MVP
gt;gt;
gt;gt; On Thu, 19 Jan 2006 17:07:30 -0600, jawdawson
gt;gt; gt; wrote:
gt;gt; gt;1 NY 10023
gt;gt; gt;
gt;gt; gt;And I need to parse that data into two separate columns.
gt;

Gord Dibben MS Excel MVP