Formula problem

[RJC]

Hi All,
Could anyone help with a formula to do these two things, please.

In A1

Have this:-
John Smith 5 or
Bill Adams 13 etc.
Just want the number extracted.

In A2
Have this:-
=8-5-11 (in other words, numbers preceeded by the equals sign).
The cell is formatted as general.
How do I just remove the equals from the front of the entry.

Thankyou,
RC

 

[Aladin Akyurek]

Hi All,
Could anyone help with a formula to do these two things, please.

In A1

Have this:-
John Smith 5 or
Bill Adams 13 etc.
Just want the number extracted.

In A2
Have this:-
=8-5-11 (in other words, numbers preceeded by the equals sign).
The cell is formatted as general.
How do I just remove the equals from the front of the entry.

Thankyou,
RC

1.

=REPLACE(A1,1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))-1,"")+0

2. Try Edit|Replace: Replace = with '

 

[RJC]

Hi Aladin,
Thanks for that.

Regarding question 2.
My cell does not always contain the equals sign, so I was looking for a formula that says "If cell A2 starts with an equals sign, then remove it".

Can this be done!
Thanks again