please help me in providing a macro to separate number from the text.
Eg; Raj[2] need to separate number form text to new rows(results) as show in Excel.
please help me in providing a macro to separate number from the text.
Eg; Raj[2] need to separate number form text to new rows(results) as show in Excel.
in B2
=RIGHT(A2,3)
copy down the column
or
Please Login or Register to view this content.
Last edited by Special-K; 05-04-2014 at 09:35 AM.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi..
Try this..
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks