Hi There,
I have another thing which for I need your help, how Can I separate numeric and alphabet value from a specific cell.
Like If I have LONDON in a cell A1, and 123456 in a2 how can I make it separate to have LONDON in Cell B1 and 12345 in a cell c2 ? substitute but may be you people can try to have simple formula for me .
Thanking you
Parveen singla