Extract a part of a text string

Hello!!!!!

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

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.

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

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

Its me again guys, ( and gals )

Another question for you guys, nice explaination OLdChippy, detail and easy to understand, not to forget, to bryan hessey also, for explaination.
Thanks alot to both of you.
Need help from you all again.

Here goes my question, if i were to extract from A1 i use that formula, but what happens to A2, A3 and till A1000.

Is there a way other than avoiding to change to formula one by one, because one thousand is massive.

Should it be a general formula, for the whole column or , is there somehting that will automatic change the A1 to A2 to A3 accordingly.

And another question, how can i put one same formula in one whole column without, inserting the formula one by one.

Sorry if my question is confusing, still learning english in process.

Thanks in advance.

Hello again Angeluz,

What you need is the fill-handle to copy your formula down. If you have your data in column A and your formula in B1, you can use the fill-handle to copy that formula down column B as far as you need. See link on fill-handle

http://www.mvps.org/dmcritchie/excel/fillhand.htm

Glad you're sorted - thanks for the feedback