Yes it is at least the size length info is always in front but could vary
from 10-12 charcters. However the text is either 1 to 2 spaces out so the
text lines up. My question to you bill is the (""",A1)) quotations represent
the number of spaces needed to extract. ?

"Biff" wrote:

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!