How do I split 16 char text 'XX XXX= +. X' into 16 columns

J

Jeff

I knew that Lotus 1-2-3 has Parse function but not sure if Excel has similar
function too. Thanks.
 
B

Bob Phillips

=mid(a1,column(a1,1)

in B1 and copy across

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
N

Norman Jones

Hi Jeff,

See the Data | Text to Columns feature.

If you select the 'Fixed width' option, column breaks can be inserted after
each character with a mouse click..
 
R

RagDyeR

One way,

Select data column, then
<Data> <TextToColumns> <Fixed Width> <Next>
Click in the Preview window to create the break lines to separate the
digits,
Then <Finish>
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I knew that Lotus 1-2-3 has Parse function but not sure if Excel has similar
function too. Thanks.
 
J

Jeff

Hi Bob, thanks. 2nd column's formula will be =mid(b1,column(b1),1) when copy
across. It should be =mid(a1,column(b1),1). Any idea how first to default 1st
field to be 'a1' ?
 
J

Jeff

Hi Norman, I got it now. Thanks a lot.

Norman Jones said:
Hi Jeff,

See the Data | Text to Columns feature.

If you select the 'Fixed width' option, column breaks can be inserted after
each character with a mouse click..
Click to expand...
 
B

Bob Phillips

Sorry, my bad

=mid($a$1,column(a1,1)


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top