Ok, you've been "warned" !!!! <VBG

Formula for cell B1:

=LEFT(A1,FIND(CHAR(10),A1)-1)

Formula for C1:

=LEFT(SUBSTITUTE(A1,B1&CHAR(10),""),FIND(CHAR(10), SUBSTITUTE(A1,B1&CHAR(10),""))-1)

Formula for D1:

=LEFT(SUBSTITUTE(A1,B1&CHAR(10)&C1&CHAR(10),""),FI ND(CHAR(10),SUBSTITUTE(A1,B1&CHAR(10)&C1&CHAR(10), ""))-1)

Formula for E1:

=MID(SUBSTITUTE(A1,B1&CHAR(10)&C1&CHAR(10)&D1&CHAR (10),""),1,255)

Note: no error checking. Assumes all entries will have the same format of 4
lines.

See, I told you it would be easier to use Text to Columns first, then
reassemble the original entry!!!

Biff

"Carrguy" wrote in message
...
I tried that. I wouldlike to keep all information in cell A1 as well. As
well
as create a formula that takes the desired information and places it in
the
B1-E1 cells. Any other suggestions would be greatly apprecieated


"Ron Coderre" wrote:

I think this might be the easiest way....

Select your column of data.

From the Excel main menu:
<data<text-to-columns
Select: Delimited.....Click [Next]
Check: Other
Click in the character box next to other
Hold down the [Alt] key...type 0010....release the [Alt] key

(That sets line break as the delimiter)
Click the [Finish] button

That should parse the Col_A items across to the right at each linebreak

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Carrguy" wrote:

A1 B1 C1 D1 E1
Detail "B"
Feature #21
1.0265 dia
±.010 Detail "B" Feature #21 1.0265 Dia ±.010

Basically I want to take the first line and want to place it in B1.
Second
line to be in C1. I want to extract contents from A1 to the respective
cells
to the right. I need a formula in which I can put into place as I have
100+
lines to do and want to take the formula and carry it down the spread
sheet.
Information changes on each line such as detail, feature and my
tolerances.
All lines in cell A1 are ALT Entered to go to next line I would have
made it
into four original cells but, I can't convince work to do it. So this
is what
I have to work with. It is a locked forum. I am sure I need a formula
in each
cell B1,E1 to do this but unable to find one. I am not sure if I can
post my
email but will do so. If you can give me a formula you can email it to
me
that would be great,