Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
microsoft.public.excel.worksheet.functions
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. |
#2
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
microsoft.public.excel.worksheet.functions
Ian Edmont wrote: 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. Sorry, please ignore this one! Still getting used to posting in Google! Ian Edmont. |
#3
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
microsoft.public.excel.worksheet.functions
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)) -- Gary "Ian Edmont" wrote in message oups.com... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
microsoft.public.excel.worksheet.functions
Excellent, thanks Garry. Works a treat.
Ian Edmont. Gary Keramidas wrote: 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)) -- Gary "Ian Edmont" wrote in message oups.com... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|