Hey,
I tried formatting the series of cells with the formula "Proper()" to the text from "sample data" to "Sample Data". When i tried copying it as formula and paste it and apply to the consecutive cells, i'm not able to do it. Only the formatting is updated to the first and least cell in the series :'(... Am i missing something here... kindly help me with this?? (like how to apply the same formatting to the many cells...
Thanks
Prabhu
I tried formatting the series of cells with the formula "Proper()" to the text from "sample data" to "Sample Data". When i tried copying it as formula and paste it and apply to the consecutive cells, i'm not able to do it. Only the formatting is updated to the first and least cell in the series :'(... Am i missing something here... kindly help me with this?? (like how to apply the same formatting to the many cells...
Thanks
Prabhu