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

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

=mid(a1,column(a1,1)

in B1 and copy across

--

HTH

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


"Jeff" <Jeff @discussions.microsoft.com wrote in message
...
I knew that Lotus 1-2-3 has Parse function but not sure if Excel has
similar
function too. Thanks.

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..


---
Regards,
Norman



"Jeff" <Jeff @discussions.microsoft.com wrote in message
...
I knew that Lotus 1-2-3 has Parse function but not sure if Excel has
similar
function too. Thanks.

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!
================================================== ===

"Jeff" <Jeff @discussions.microsoft.com wrote in message
...
I knew that Lotus 1-2-3 has Parse function but not sure if Excel has similar
function too. Thanks.

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' ?

"Bob Phillips" wrote:

=mid(a1,column(a1,1)

in B1 and copy across

--

HTH

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


"Jeff" <Jeff @discussions.microsoft.com wrote in message
...
I knew that Lotus 1-2-3 has Parse function but not sure if Excel has
similar
function too. Thanks.

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

"Norman Jones" wrote:

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..


---
Regards,
Norman



"Jeff" <Jeff @discussions.microsoft.com wrote in message
...
I knew that Lotus 1-2-3 has Parse function but not sure if Excel has
similar
function too. Thanks.

Hi RDR, thank you.

Rgds..Jeff

"RagDyeR" wrote:

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!
================================================== ===

"Jeff" <Jeff @discussions.microsoft.com wrote in message
...
I knew that Lotus 1-2-3 has Parse function but not sure if Excel has similar
function too. Thanks.

Sorry, my bad

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


--

HTH

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


"Jeff" wrote in message
...
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' ?

"Bob Phillips" wrote:

=mid(a1,column(a1,1)

in B1 and copy across

--

HTH

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


"Jeff" <Jeff @discussions.microsoft.com wrote in message
...
I knew that Lotus 1-2-3 has Parse function but not sure if Excel has
similar
function too. Thanks.

Thank you.


"Bob Phillips" wrote:

Sorry, my bad

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


--

HTH

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


"Jeff" wrote in message
...
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' ?

"Bob Phillips" wrote:

=mid(a1,column(a1,1)

in B1 and copy across

--

HTH

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


"Jeff" <Jeff @discussions.microsoft.com wrote in message
...
I knew that Lotus 1-2-3 has Parse function but not sure if Excel has
similar
function too. Thanks.

Excel calls it Text-to-Columns - it is under the Data menu
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jeff" <Jeff @discussions.microsoft.com wrote in message
...
I knew that Lotus 1-2-3 has Parse function but not sure if Excel has
similar
function too. Thanks.