Move currency symbol into another column by Regex or by other ways

[taps]

Dear Team

I have a set of data where I am getting amount with the currency symbol (sometime without). Is there any way to move this symbol to next column and separate the digit parts (comma and decimal can exist). I am not good in regular expression but it is my favourite.

The Regular expression can apply here in the following way::::
1. Copy the actual data into two different columns.
2. From one column replace the currency symbol ($, INR, GBP etc.). ie. LOGIC is -- Remove all character from the text except comma, decimal point and space. Thus the cell will contain only digits (with comma, decimal and space if any-the space can remove by find-replace later).
3. From another column replace the digits, comma, decimal points and space, so that we can get the currency symbol only.

May be there are some easier way to get the solution, I am eager to know.
Move Currency Symbol.jpg

Thanks in advance for your support.

Regards
taps
Move currency symbol.xlsx

[antoka05]

See the attached file where I used this macro:

Please Login or Register  to view this content.

Regards,
Antonio

[taps]

Dear antoka05

Thanks a ton for your reply. It is working absolutely fine.

I have also get similar topics while searching for solution in below links. May be this is helpful for other friends.

http://www.mrexcel.com/forum/excel-q...cy-symbol.html

Thanks again.

Regards
taps