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