Re: $$Excel-Macros$$ how to separate these cells

2010-08-29 Thread Chandra Gupta
Hi Dear There is problem because cells are in custom format. You should enter this in general format. Chandra Gupta Maurya On Sun, Aug 29, 2010 at 9:51 AM, Ankit Agrawal wrote: > Hello Sir, > > I need help in separate the num & alpha value in the one cell into another > two cells.so i am attach

$$Excel-Macros$$ how to separate these cells

2010-08-28 Thread Ankit Agrawal
Hello Sir, I need help in separate the num & alpha value in the one cell into another two cells.so i am attaching a sample file in it, in sample file I have two column and having the num and alpha value like 14.300kg or 23.30/kg so on... and I have to separate these value in two column like 14.300