software

Looking for a way to make the cells in column B based on the contents
of cells in colum A (text string) show as below please?

Column AColumn B
11
1.11
1.1.11
1.1.1.1 1
1010
10.110
10.1.110
10.1.1.110
100100
100.1100
100.1.1100
100.1.1.1100

I'd like to have a formula in each cell in column B that will return
the text string up to the first occurence of the decimal point in
column A but if a decimal point is not found then return the value in
column A anyway.

Hope that makes sense!?!?

Many thanks.

Ian Edmont.
Ian Edmont wrote:

gt; Looking for a way to make the cells in column B based on the contents
gt; of cells in colum A (text string) show as below please?
gt;
gt; Column AColumn B
gt; 11
gt; 1.11
gt; 1.1.11
gt; 1.1.1.1 1
gt; 1010
gt; 10.110
gt; 10.1.110
gt; 10.1.1.110
gt; 100100
gt; 100.1100
gt; 100.1.1100
gt; 100.1.1.1100
gt;
gt; I'd like to have a formula in each cell in column B that will return
gt; the text string up to the first occurence of the decimal point in
gt; column A but if a decimal point is not found then return the value in
gt; column A anyway.
gt;
gt; Hope that makes sense!?!?
gt;
gt; Many thanks.
gt;
gt; Ian Edmont.

Sorry, please ignore this one! Still getting used to posting in Google!

Ian Edmont.here's a formula that may do what you want. just drag down the column

=IF(ISERROR(FIND(quot;.quot;,A1,1)),A1,LEFT(A1,FIND(quot;.quot;,A1 ,1)-1))

--Garyquot;Ian Edmontquot; gt; wrote in message oups.com...
gt; Looking for a way to make the cells in column B based on the contents
gt; of cells in colum A (text string) show as below please?
gt;
gt; Column A Column B
gt; 1 1
gt; 1.1 1
gt; 1.1.1 1
gt; 1.1.1.1 1
gt; 10 10
gt; 10.1 10
gt; 10.1.1 10
gt; 10.1.1.1 10
gt; 100 100
gt; 100.1 100
gt; 100.1.1 100
gt; 100.1.1.1 100
gt;
gt; I'd like to have a formula in each cell in column B that will return
gt; the text string up to the first occurence of the decimal point in
gt; column A but if a decimal point is not found then return the value in
gt; column A anyway.
gt;
gt; Hope that makes sense!?!?
gt;
gt; Many thanks.
gt;
gt; Ian Edmont.
gt;
Excellent, thanks Garry. Works a treat.

Ian Edmont.Gary Keramidas wrote:
gt; here's a formula that may do what you want. just drag down the column
gt;
gt; =IF(ISERROR(FIND(quot;.quot;,A1,1)),A1,LEFT(A1,FIND(quot;.quot;,A1 ,1)-1))
gt;
gt; --
gt;
gt;
gt; Gary
gt;
gt;
gt; quot;Ian Edmontquot; gt; wrote in message
gt; oups.com...
gt; gt; Looking for a way to make the cells in column B based on the contents
gt; gt; of cells in colum A (text string) show as below please?
gt; gt;
gt; gt; Column A Column B
gt; gt; 1 1
gt; gt; 1.1 1
gt; gt; 1.1.1 1
gt; gt; 1.1.1.1 1
gt; gt; 10 10
gt; gt; 10.1 10
gt; gt; 10.1.1 10
gt; gt; 10.1.1.1 10
gt; gt; 100 100
gt; gt; 100.1 100
gt; gt; 100.1.1 100
gt; gt; 100.1.1.1 100
gt; gt;
gt; gt; I'd like to have a formula in each cell in column B that will return
gt; gt; the text string up to the first occurence of the decimal point in
gt; gt; column A but if a decimal point is not found then return the value in
gt; gt; column A anyway.
gt; gt;
gt; gt; Hope that makes sense!?!?
gt; gt;
gt; gt; Many thanks.
gt; gt;
gt; gt; Ian Edmont.
gt; gt;