Number From Text

RobertN · Sep 7, 2004

Hi all,

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

Total: 10623437.55
Total: 6725000.

Frank Kabel · Sep 7, 2004

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

RobertN · Sep 7, 2004

Works great. Thanks Frank.

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

--
Regards
Frank Kabel
Frankfurt, Germany

.