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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 12:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com