Thanks for the help. It worked fine.
There is one problem,...... and I think it has something to do with
formatting.
When I seprated the numbers, I noticed that the first number (which
remained in it's original position) has a leading space which was
existing when I copied and pasted from a website.
This will not allow it to act numericly. The rest of the numbers are
OK.
The original info looked like the following;
NAICS Codes:*562111
NAICS Codes:*541512
NAICS Codes:*42149, 42184, 42212, 42213
NAICS Codes:*323122, 323114, 541922
NAICS Codes:*541512, 541519
NAICS Codes:*423810, 424990, 423820, 424690, 532412
NAICS Codes:*236210, 236220, 237110, 237310, 237990, 541330, 541380
NAICS Codes:*56291, 56121, 23816, 23891
NAICS Codes:*54191, 541611, 54163
NAICS Codes:*524210
NAICS Codes:*541614
I then did a find and replace
FIND: NAICS Codes:
REPALCE ALL: (I left it blank)
This resulted in the numbers you see below.
Is there any way that I can fix this?
Thanks Again
Tom Snyder
On Thu, 16 Jun 2005 09:50:28 -0600, JE McGimpsey
wrote:
Data/Text to Columns/Delimited/Comma
In article ,
lehigh46 wrote:
Hi All,
I have copied a small sample of a spread sheet which contains the
following numbers and they resides in column A.
*562111
*541512
*42149, 42184, 42212, 42213
*323122, 323114, 541922
*541512, 541519
*423810, 424990, 423820, 424690, 532412
*236210, 236220, 237110, 237310, 237990, 541330, 541380
*56291, 56121, 23816, 23891
*54191, 541611, 54163
*524210
*541614
I would like to seperate the numbers into columns B, C, D, E, and so
on, starting with the first number in column B.
Notice that the numbers are not all the same length.
Can anyone tell me how I can accomplish this?
Thanks for your help
Tom Snyder
x-- 100 Proof News - http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 100,000 other groups
x-- Access to over 1.6 Terabytes per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD
x-- 100 Proof News -
http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 100,000 other groups
x-- Access to over 1.6 Terabytes per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD