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
New Excel Forum
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
|
|
Unlocking the Mysteries of Excel
|
