Hi All,
I want to remove parenthesis from the numbers in the cell. then i will separate the two numbers in two different cells. My data look like this:
A1
9520 (8900)
desired format
A1 B1
9520 8900
Is there any way to remove the parenthesis and separate the two numbers.
This would be great help to me....
Thanks in Advance..
With Sincere Regards,
Upananda
Bookmarks