Sorry to butt in on this one - I have used your suggestion to extract
numbers - very good method!
However, with the result (which is two cells added together) I would now
like to put another text sting in front of the result, i.e. ="Total =
"&...your extraction forumula here...
However, this only gives me the text, but not the total number which I get
without trying to add the text string at the front.
I have looked at many of the other mind boggling ways of extracting numbers,
but like this one as it's fairly straight forwards - especially as you
explained it!!
Sorry to butt in on this one - I have used your suggestion to extract
numbers - very good method!
However, with the result (which is two cells added together) I would now
like to put another text sting in front of the result, i.e. ="Total =
"&...your extraction forumula here...
However, this only gives me the text, but not the total number which I get
without trying to add the text string at the front.
I have looked at many of the other mind boggling ways of extracting numbers,
but like this one as it's fairly straight forwards - especially as you
explained it!!
That formula doesn't specifically extract numbers per se, it extracts the
last "word" from a string. In this thread the OP's data just happened to
have a string of numbers as *the last word*.
That formula doesn't specifically extract numbers per se, it extracts the
last "word" from a string. In this thread the OP's data just happened to
have a string of numbers as *the last word*.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
