isolate a number in cell with text and numbers

[T. Valko]

You're welcome. Thanks for the feedback!

 

[AJ]

Hi

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!!

Many thanks

Andrew

 

[AJ]

Hi

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!!

Many thanks

Andrew

 

[T. Valko]

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*.

So, if:

A1 = The total for January is 100

="Total = "&TRIM(RIGHT(SUBSTITUTE(TRIM(A1)," ",REPT(" ",255)),255))

Returns:

Total = 100

 

[T. Valko]

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*.

So, if:

A1 = The total for January is 100

="Total = "&TRIM(RIGHT(SUBSTITUTE(TRIM(A1)," ",REPT(" ",255)),255))

Returns:

Total = 100