extracting numbers between text

Try this...

Data Range

	A	B	C	D
1	------	------	------	------
2	90x90x7	90	90	7
3	120x90x8	120	90	8
4	150x150x12	150	150	12

This formula entered in B2 and copied across to D2:

=--TRIM(MID(SUBSTITUTE("x"&$A2,"x",REPT(" ",255)),COLUMNS($B2:B2)*255,255))

Assumes no numbers start with leading zeros.

Use this formula in B1 and pull it to the right until you see blanks and then down

=--TRIM(MID(SUBSTITUTE("x"&$A1,"x",REPT(" ",50)),50*COLUMNS($A:A),50))

Row\Col	A	B	C	D
1	90x90x7	90	90	7
2	120x90x8	120	90	8
3	150x150x12	150	150	12

Hi, welcome to the forum

Assuming your data starts in row 2...
=--TRIM(MID(SUBSTITUTE($A2,"x",REPT(" ",LEN($A2))),LEN($A2)*(COLUMN()-2)+1,LEN($A2)))
copied down

Hell of an echo (echo, echo, echo, ...) on this one

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

No echo here

With the built in Text to column and use X as seperator.

See the attached file.

@oeldere: the OP said ...

I know of the deliminator function does this, however I cant use this and I am looking for formulas that would work in its place.

@TMS

Please Login or Register  to view this content.

It can be used, since the result is the same.

Some members think that the delimited result comes in the place of the original data.

But you can select another cell, in this case B1. (see the attached file in #8).

If this is not the case, I would like to know from the OP, why it can't be used.