Formula problem

RJC

Active Member
Joined
Jul 29, 2003
Messages
252
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
 

Some videos you may like

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.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,192
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

Active Member
Joined
Jul 29, 2003
Messages
252
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,507
Messages
5,523,308
Members
409,509
Latest member
CheekyDevil2386

This Week's Hot Topics

Top