microsoft.public.excel.worksheet.functions

  • Thread starter Thread starter Ian Edmont
  • Start date Start date
I

Ian Edmont

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 A Column B
1 1
1.1 1
1.1.1 1
1.1.1.1 1
10 10
10.1 10
10.1.1 10
10.1.1.1 10
100 100
100.1 100
100.1.1 100
100.1.1.1 100

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 said:
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 A Column B
1 1
1.1 1
1.1.1 1
1.1.1.1 1
10 10
10.1 10
10.1.1 10
10.1.1.1 10
100 100
100.1 100
100.1.1 100
100.1.1.1 100

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.
Click to expand...

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(".",A1,1)),A1,LEFT(A1,FIND(".",A1,1)-1))
 
Back
Top