Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jeff
 
Posts: n/a
Default 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.
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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



  #3   Report Post  
Norman Jones
 
Posts: n/a
Default

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.



  #4   Report Post  
RagDyeR
 
Posts: n/a
Default

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.


  #5   Report Post  
Jeff
 
Posts: n/a
Default

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.






  #6   Report Post  
Jeff
 
Posts: n/a
Default

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.




  #7   Report Post  
Jeff
 
Posts: n/a
Default

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.



  #8   Report Post  
Bob Phillips
 
Posts: n/a
Default

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.






  #9   Report Post  
Jeff
 
Posts: n/a
Default

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.






  #10   Report Post  
Bernard Liengme
 
Posts: n/a
Default

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Split Long Text Cell into Two Shorter Cells Without Splitting Word Naomi T Excel Discussion (Misc queries) 1 July 7th 05 06:49 AM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
Create a formula to remove text to the left of specified char? TheLazer Excel Worksheet Functions 3 May 18th 05 11:59 AM
Can I split a cell diagonally, with text in each triangle ? Helen T Excel Discussion (Misc queries) 1 May 13th 05 04:32 PM
How do I split a column having numbers and text in a random order rana8689 Excel Worksheet Functions 2 December 17th 04 10:14 PM


All times are GMT +1. The time now is 09:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"