Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SEPERATE NUMBERS IN A CELL
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
isolate numbers in a cell | New Users to Excel | |||
Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
many numbers in one cell separated by hyphen. | Excel Discussion (Misc queries) | |||
How do I format a cell so that only specific numbers can be enter. | Excel Discussion (Misc queries) | |||
Averaging Numbers when 2 numbers in one cell | Excel Worksheet Functions |