Number From Text

[RobertN]

Hi all,

How do I extract numbers from text fields like the
following? Thanks.

Total: 10623437.55
Total: 6725000.

 

[Frank Kabel]

Hi
if they all start with 'Total:' try:
=--TRIM(SUBSTITUTE(A1,"Total:",""))

 

[RobertN]

Works great. Thanks Frank.

-----Original Message-----
Hi
if they all start with 'Total:' try:
=--TRIM(SUBSTITUTE(A1,"Total:",""))

--
Regards
Frank Kabel
Frankfurt, Germany


.