Ron, what means the 1,255 at the end of the formula?

thanks
Marcelo from Brazil



"Ron Coderre" escreveu:

A less complicated way:

B1: =--(RIGHT(A1,1)&MID(LEFT(A1,LEN(A1)-1),SEARCH(":",A1)+1,255))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

Try this:

B1:
=--(RIGHT(A1,1)&MID(LEFT(A1,LEN(A1)-1),MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},LEFT(A1,LEN(A1 )-1)&"0123456789")),99))

Copy that formula down as far as you need.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Doug" wrote:


I am trying to take out the number value from cells A1 to A3 and return them
in a value that i can sum in B4.i can take the text out by using the formula
below,my problem is that the + and - figures appear at the end of the number
and so cannot be "sumed".Can they be returned in front of the number or
return as a +or- figure so i can sum them?
Any help appreciated.

A B
1 Tot Val: 5.70- 5.70-
2 Tot Val: 6.64+ 6.64+
3 Tot Val: .00+ .00+

=SUBSTITUTE(A1,"Tot Val:","")

Doug M