Application of the LEFT, RIGHT, or MID functions could easily extract out the
data you require, but depend of consistant formatting of the
information........for example, =LEFT(A1,10) would get 10' x 0-6" out of the
sample you provided (if it were in A1), but may not be applicable for other
lines...........we would need several sample lines of data to maybe come up
with something better.......

Vaya con Dios,
Chuck, CABGx3


"Greg" wrote:

I have a cell that is combined with a series of numbers and text that
describes some pipe information. I want to be able to extract the pipe size
and lenght numbers into another column and remove from text cell so they are
separate columns. Ex: 10' x 0-6" Ductile Iron CL53 SPL Pipe Expoxy Coated.
Any help!