Extract numeric value from a cell where Text and Numeric combined in a cell

[Chandrahaas]

Dear All,

Can someone please help with me with the below Macro.

Currently, I am able to extract a Text, but I want to extract Numeric value from the below Code

Please Login or Register  to view this content.

Please help asap

Thank in advance

Chandru

[zbor]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Chandrahaas]

It would be very helpful

[JOHN H. DAVIS]

Try this UDF from Ozgrid.

Please Login or Register  to view this content.

Your code modified:

Please Login or Register  to view this content.

[Chandrahaas]

The Code is not working and throwing an error message.

Here is the example and extecped output and also attached a sample file for your reference.

Current Value Expected Output
Amount currency code
203,969.00 EUR 203,969.00 EUR

Kind regards,
Chandru

[JOHN H. DAVIS]

The Code is not working and throwing an error message.

Here is the example and extecped output and also attached a sample file for your reference.

Current Value Expected Output
Amount currency code
203,969.00 EUR 203,969.00 EUR

Kind regards,
Chandru

Can't tell what you want from your post? Your output appears to be the same as your input. Does this help?

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Or do you want a combined code?

Please Login or Register  to view this content.

[sktneer]

@JOHN H. DAVIS
I think OP needs to show the desired output as well.

[JOHN H. DAVIS]

@sktneer - I think post 7 is what she/he is after. When I replied with quotes Post 6 kinda lined up. Let's see.

[Chandrahaas]

Hi All,

still the updated code is not working. Please help

[sktneer]

Hi All,

still the updated code is not working. Please help

I can see that you are interested only in telling that the code is not working. But probably you don't think that it is necessary to read all the replies above to know what is going on here and what the members expect from you. Read the post# 6, 7, 8 and 9.

If you get an error during the code, you need to debug it to know which line of code is highlighted and you should mention that line in your reply so that the member who has provided the code would be able to suggest you the correction in the code.

Moreover its good that you uploaded the sample workbook but you didn't show what desired output you are expecting.
So please upload a sample workbook with the raw data and the expected output.

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

Didn't know you had a custom format.

[Chandrahaas]

Dear John,

Thank you Very much for your help. It worked perfectly! You're rocking

Kind Regards,
Chandru

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.

[mikerickson]

A really simple UDF to extract the value of the front of a string is

Please Login or Register  to view this content.

=MyVal(SUBSTITUTE("203,969.00 EUR", ",", "")) returns 203969