Posted to microsoft.public.excel.misc

GEM

external usenet poster

Posts: 90

Splitting Numbers into Columns.

I have under column A numbers with different lengths.
A1=125
A2=1025
A3=9
A4=589644
ETC....

I want to separate each individual number into a cell.
for example
A1=1
B1=2
C1=5
A2=1
B2=0
C2=2
D2=5
ETC...

I've tried TEXT TO COLUMNS, but I have to use fixed width, and sometimes
it's just to long, is there an easier way??

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
splitting numbers	miki peric	Excel Discussion (Misc queries)	3	January 6th 09 12:05 AM
help on splitting into columns	[email protected]	Excel Discussion (Misc queries)	5	November 8th 08 07:58 PM
Splitting Numbers	Xaenyth	Excel Discussion (Misc queries)	2	December 19th 06 05:59 PM
Splitting item numbers	Spencer	Excel Discussion (Misc queries)	5	October 11th 06 07:35 PM
Splitting Numbers Into Different Columns	Peter W Soady \(UK\)	Excel Discussion (Misc queries)	3	September 30th 06 07:57 PM

All times are GMT +1. The time now is 02:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us