Hi Josh,


My 2 cent try.

Use the text to columns function for the columm with a space " ". Now
you have everthing in multiple cells on the same row. Search the
textvalue with =IF(ISNUMBER(A1)=TRUE;A1;"") or ISTEXT function for all
the new columms etc...

Or you could do a find an replace of 10spaces = 1 space; 9 spaces =
1 spaces, 8 spaces = 1 spaces, ... 2 spaces = 1 spaces.
Then use the FIND function of the space with a formula like =LEFT
(A1;FIND(" ";A1;1)) for the text value and =RIGHT ect... for the
numeric value.

Looking forward for a simpeler solution of an expert.
Tom





Probable VBA would work better but cant help you with that.



On 29 mei, 14:21, jxbeeman wrote:
Hi,
I'm trying to find a certain data type in a cell and the position it is in. *

For example I have a text cell with the following in it "SomePartName * *
12345 * * ". *

How would i be able to find the first number position in this cell using a
formula?
How would i be able to find the last number position in this cell using a
formula?

The reason i'm looking for something like this is to be able to separate
strings of text which contain the parts name and then a number after it along
with spaces inbetween.

Thanks for the help.
Josh