Extract a part of a text string

**MaxAlbertsson** · 12-21-2006, 08:20 AM

Hello!!!!!

**oldchippy** · 12-21-2006, 08:35 AM

Here's one way. If you have your text in A1, then put this in B1

=VALUE(LEFT(A1,FIND("x",A1,1)-1)) then this in C1

=VALUE(MID(A1,FIND("x",A1,1)+1,FIND("x",A1,FIND("x",A1,1)+1)-FIND("x",A1,1)-1)) then this in D1

=VALUE(MID(A1,FIND("x",A1,FIND("x",A1,1)+1)+1,10))

All your thickness's, lenght's and width's are now in separate cells - Merry Christmas

**daddylonglegs** · 12-21-2006, 09:08 AM

If you download Morefunc add-in you could use the EVAL function, i.e.

=EVAL(SUBSTITUTE(A1,"x","*"))

For morefunc see here

http://xcell05.free.fr/

**oldchippy** · 12-21-2006, 09:16 AM

Of course another way is to select the cells and go to Data > Text to columns, then pick Delimited > Next, Tab, Other and put in an "x"
This will separate into separate cells also.

**Angeluz** · 12-26-2006, 03:03 AM

thanks alot old chippy, the functions is very useful indeed, it does what i wanted to do.
I have another request for you, would mind explaining the function abit don't really understand, im noobie

in tis function things. because eventhough it can does wut i want it to do, but i don understand what the function is telling. for example the part where the minus symbol turn up.

thanks alot .

hopefully i don;t confuse you. Sorry for the bother i cause.

Angeluz.

**Bryan Hessey** · 12-26-2006, 03:58 AM

Originally Posted by Angeluz

thanks alot old chippy, the functions is very useful indeed, it does what i wanted to do.
I have another request for you, would mind explaining the function abit don't really understand, im noobie

in tis function things. because eventhough it can does wut i want it to do, but i don understand what the function is telling. for example the part where the minus symbol turn up.

thanks alot .

hopefully i don;t confuse you. Sorry for the bother i cause.

Angeluz.

Hi,

oldchippy's formula

=VALUE(LEFT(A1,FIND("x",A1,1)-1)) then this in C1

=VALUE(MID(A1,FIND("x",A1,1)+1,FIND("x",A1,FIND("x ",A1,1)+1)-FIND("x",A1,1)-1)) then this in D1

=VALUE(MID(A1,FIND("x",A1,FIND("x",A1,1)+1)+1,10))

is to use the left or middle characters according to the position of the 'x' character(s) -1 to get before the x, +1 to get the characters after the x

thus the first is Left A1 up to the character before the x
the second 'Mid' uses the find 3 times to locate the centre characters,
and the last finds the character after the 2nd x (with the +1) and goes from there to the end (providing the end is within 10 characters.

Hope this helps.
---

**oldchippy** · 12-26-2006, 08:17 AM

Originally Posted by Angeluz

thanks alot old chippy, the functions is very useful indeed, it does what i wanted to do.
I have another request for you, would mind explaining the function abit don't really understand, im noobie

in tis function things. because eventhough it can does wut i want it to do, but i don understand what the function is telling. for example the part where the minus symbol turn up.

thanks alot .

hopefully i don;t confuse you. Sorry for the bother i cause.

Angeluz.

Here's a complete breakdown on how you can build up complete formulas