Breaking numbers out of a string

[ToddG]

I have a group of cells that contain sizes:

4 x 32 x 1
14.375 x 17.5 x 1.25
7.5 x 12.625 x 1.5

I am using the following code to search for the first
blank space and return the number tho the left of the
blank space:

=VALUE(LEFT(A1,SEARCH(" ",A1,1)-1))

What I need now is to (in another cell) return the middle
number and in another cell return the last number so I
will end up with this:

ColumnA ColumnB ColumnC
4 32 1
14.375 17.5 1.25
7.5 12.625 1.5

Thanks,

Todd

 

[Frank Kabel]

Hi Todd
if they are all separated by ' x ' you may use 'Data - Text to columns'
for this

 

[ToddG]

Great suggestion, Frank. I've never used that tool before.
Thank you