# Formula problem

#### RJC

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

In A1

Have this:-
John Smith 5 or
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

### Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

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

In A1

Have this:-
John Smith 5 or
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

##### Active Member
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

Replies
6
Views
59
Replies
5
Views
36
Replies
4
Views
71
Replies
6
Views
51
Replies
4
Views
42