Numbers only

Bal_Ocado

New Member
Joined
Dec 18, 2013
Messages
38
A
B
C
D
E
Prod A
1234
yell
thi
Prod B
1234
owe
rfd
Prod C
rew
2344
feft
Prod D
yth
defg
3232

<tbody>
</tbody>

Hi Guys,

I have an issue with a formula I cannot resolve. As you can see from the table above,I have three rows of information, which I need to collate into 1. Essentially, one of the columns B,C or D has a price (number), the other two columns will not be a number but writing.

Unforunately, my data is a bit different, so the price will always be in one of the 3 columns. Is there a formula I can use in column E to always extract the number?

Thanks in advance!
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Alan_P

Well-known Member
Joined
Jul 8, 2014
Messages
596
Hi Bal_Ocado,

If the other 3 of the 4 columns are always text then you can just use Sum to extract the number?

=SUM(A1:D1)

Cheers,
Alan.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,911
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top