Hi!

If the format is ALWAYS the same:

=LEFT(A1,FIND("""",A1))

Biff

"Greg" wrote in message
...
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!