software

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-6quot; Ductile Iron CL53 SPL Pipe Expoxy Coated.
Any help!

Hi!

If the format is ALWAYS the same:

=LEFT(A1,FIND(quot;quot;quot;quot;,A1))

Biff

quot;Gregquot; gt; wrote in message
...
gt;I have a cell that is combined with a series of numbers and text that
gt; describes some pipe information. I want to be able to extract the pipe
gt; size
gt; and lenght numbers into another column and remove from text cell so they
gt; are
gt; separate columns. Ex: 10' x 0-6quot; Ductile Iron CL53 SPL Pipe Expoxy
gt; Coated.
gt; Any help!
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-6quot; 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, CABGx3quot;Gregquot; wrote:

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

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 (quot;quot;quot;,A1)) quotations represent
the number of spaces needed to extract. ?

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; If the format is ALWAYS the same:
gt;
gt; =LEFT(A1,FIND(quot;quot;quot;quot;,A1))
gt;
gt; Biff
gt;
gt; quot;Gregquot; gt; wrote in message
gt; ...
gt; gt;I have a cell that is combined with a series of numbers and text that
gt; gt; describes some pipe information. I want to be able to extract the pipe
gt; gt; size
gt; gt; and lenght numbers into another column and remove from text cell so they
gt; gt; are
gt; gt; separate columns. Ex: 10' x 0-6quot; Ductile Iron CL53 SPL Pipe Expoxy
gt; gt; Coated.
gt; gt; Any help!
gt;
gt;
gt;

In light of that, then as an alternative you could use Data gt; TextToColumns
with a fixed delimiter set 12 characters in from the left edge and do not
import the rest of the description..........then if you have any alpha
characters left in that column, ASAP Utilities (free at
www.asap-utilities.com) can remove them. and if you're doing this
frequently, it can all be written in to a macro and done with the push of a
button........

Vaya con Dios,
Chuck, CABGx3quot;Gregquot; wrote:

gt; Yes it is at least the size length info is always in front but could vary
gt; from 10-12 charcters. However the text is either 1 to 2 spaces out so the
gt; text lines up. My question to you bill is the (quot;quot;quot;,A1)) quotations represent
gt; the number of spaces needed to extract. ?
gt;
gt; quot;Biffquot; wrote:
gt;
gt; gt; Hi!
gt; gt;
gt; gt; If the format is ALWAYS the same:
gt; gt;
gt; gt; =LEFT(A1,FIND(quot;quot;quot;quot;,A1))
gt; gt;
gt; gt; Biff
gt; gt;
gt; gt; quot;Gregquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I have a cell that is combined with a series of numbers and text that
gt; gt; gt; describes some pipe information. I want to be able to extract the pipe
gt; gt; gt; size
gt; gt; gt; and lenght numbers into another column and remove from text cell so they
gt; gt; gt; are
gt; gt; gt; separate columns. Ex: 10' x 0-6quot; Ductile Iron CL53 SPL Pipe Expoxy
gt; gt; gt; Coated.
gt; gt; gt; Any help!
gt; gt;
gt; gt;
gt; gt;

gt;is the (quot;quot;quot;,A1)) quotations represent the number
gt;of spaces needed to extract. ?

It's 4 double quotes: quot;quot;quot;quot;

No, it has nothing to do with spaces. It's looking for the double quote that
represent the inches:

10' x 0-6|quot;| Ductile Iron CL53 SPL Pipe Expoxy

When (if) it finds the double quote, it returns everything to the left. I'm
assuming every entry contains a double quote. That's why I asked if the
format is ALWAYS the same.

Biff

quot;Gregquot; gt; wrote in message
...
gt; Yes it is at least the size length info is always in front but could vary
gt; from 10-12 charcters. However the text is either 1 to 2 spaces out so the
gt; text lines up. My question to you bill is the (quot;quot;quot;,A1)) quotations
gt; represent
gt; the number of spaces needed to extract. ?
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; If the format is ALWAYS the same:
gt;gt;
gt;gt; =LEFT(A1,FIND(quot;quot;quot;quot;,A1))
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Gregquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a cell that is combined with a series of numbers and text that
gt;gt; gt; describes some pipe information. I want to be able to extract the pipe
gt;gt; gt; size
gt;gt; gt; and lenght numbers into another column and remove from text cell so
gt;gt; gt; they
gt;gt; gt; are
gt;gt; gt; separate columns. Ex: 10' x 0-6quot; Ductile Iron CL53 SPL Pipe Expoxy
gt;gt; gt; Coated.
gt;gt; gt; Any help!
gt;gt;
gt;gt;
gt;gt;