separate data in a column in excel
If the values are numbers starting in A1
in B1 =INT(A1) in C1 =(A1-B1)*100 if they are text =LEFT(A1,FIND(".",A1)-1) and =SUBSTITUTE(A1,B1&".","") Regards, Peo Sjoblom "Larry" wrote: Is there a function to separate values (besides text to columns) in a column similar to the formula used to combine data. I'd like to separate a column of decimals, say 14.25, 5.50 and 100.00 into colums containing 14 and 25, 5 and 50, 100 and 00. Thanks. |
All times are GMT +1. The time now is 06:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com