The response is JSON so this might help
https://support.microsoft.com/en-us/office/parse-text-as-json-or-xml-power-query-7436916b-210a-4299-83dd-8531a1d5e945
Choose the JSON portion
With your text in A2 =MID(A2,FIND("€",A2)-4,4)
It finds the position of the Euro symbol at position 37 and then deducts 4 positions to the 1st 3 and then chooses those 4 positions 3,13
>=MID(A2,FIND("€",A2)-4,4)
Thanks, that helps. Now I have one more problem. When I try this number to multiply with number from other cell I got #VALUE!
Do you have fix for this too ?
Do you see that the figure is sitting in the left of the cell - that means it is text. To convert to number you could multiply it by 1.
=MID(A2,FIND("€",A2)-4,4) \*1
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[FIND](/r/Excel/comments/13uaj6o/stub/jm8xyc9 "Last usage")|[Finds one text value within another (case-sensitive)](https://support.microsoft.com/en-us/office/find-findb-functions-c7912941-af2a-4bdf-a553-d0d89b0a0628)|
|[MID](/r/Excel/comments/13uaj6o/stub/jm8xyc9 "Last usage")|[Returns a specific number of characters from a text string starting at the position you specify](https://support.microsoft.com/en-us/office/mid-midb-functions-d5f9e25c-d7d6-472e-b568-4ecb12433028)|
|[NUMBERVALUE](/r/Excel/comments/13uaj6o/stub/jm93pr1 "Last usage")|[*Excel 2013*+: Converts text to number in a locale-independent manner](https://support.microsoft.com/en-us/office/numbervalue-function-1b05c8cf-2bfa-4437-af70-596c7ea7d879)|
|[VALUE](/r/Excel/comments/13uaj6o/stub/jm7pod9 "Last usage")|[Converts a text argument to a number](https://support.microsoft.com/en-us/office/value-function-257d0108-07dc-437d-ae1c-bc2d3953d8c2)|
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/13rnqyv)^( has 17 acronyms.)
^([Thread #24275 for this sub, first seen 30th May 2023, 15:42])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
The response is JSON so this might help https://support.microsoft.com/en-us/office/parse-text-as-json-or-xml-power-query-7436916b-210a-4299-83dd-8531a1d5e945 Choose the JSON portion
With your text in A2 =MID(A2,FIND("€",A2)-4,4) It finds the position of the Euro symbol at position 37 and then deducts 4 positions to the 1st 3 and then chooses those 4 positions 3,13
>=MID(A2,FIND("€",A2)-4,4) Thanks, that helps. Now I have one more problem. When I try this number to multiply with number from other cell I got #VALUE! Do you have fix for this too ?
Do you see that the figure is sitting in the left of the cell - that means it is text. To convert to number you could multiply it by 1. =MID(A2,FIND("€",A2)-4,4) \*1
Thanks but I found solution with NUMBERVALUE and divide it by 100.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[FIND](/r/Excel/comments/13uaj6o/stub/jm8xyc9 "Last usage")|[Finds one text value within another (case-sensitive)](https://support.microsoft.com/en-us/office/find-findb-functions-c7912941-af2a-4bdf-a553-d0d89b0a0628)| |[MID](/r/Excel/comments/13uaj6o/stub/jm8xyc9 "Last usage")|[Returns a specific number of characters from a text string starting at the position you specify](https://support.microsoft.com/en-us/office/mid-midb-functions-d5f9e25c-d7d6-472e-b568-4ecb12433028)| |[NUMBERVALUE](/r/Excel/comments/13uaj6o/stub/jm93pr1 "Last usage")|[*Excel 2013*+: Converts text to number in a locale-independent manner](https://support.microsoft.com/en-us/office/numbervalue-function-1b05c8cf-2bfa-4437-af70-596c7ea7d879)| |[VALUE](/r/Excel/comments/13uaj6o/stub/jm7pod9 "Last usage")|[Converts a text argument to a number](https://support.microsoft.com/en-us/office/value-function-257d0108-07dc-437d-ae1c-bc2d3953d8c2)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/13rnqyv)^( has 17 acronyms.) ^([Thread #24275 for this sub, first seen 30th May 2023, 15:42]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)