2
How would one extract a number starting with a "£" sign from a cell containing alphanumeric characters?
Example: extracting £450,000 from A1 and placing in B1. See image for example text
user15163
Posted 2014-12-22T22:55:27.190
Reputation: 23
Excel: extracting a number from mixed content cell
Answers
0
If we have a space after the number, then in B1 enter:
=MID(A1,FIND("£",A1,1)+1,9999)
and in C1 enter:
=MID(B1,1,FIND(" ",B1)-1)
For example:
Gary's Student
Posted 2014-12-22T22:55:27.190
Reputation: 15 540
Possible duplicate of How to extract numerical value after a certain string within a sentence in Excel cell. See also Extract numbers from cells containing mixed alpha-numeric strings, Extracting multiple numerical values from mixed characters in Excel worksheet, and more.
– G-Man Says 'Reinstate Monica' – 2014-12-22T23:17:59.993