# Numbers only

##### New Member
 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?

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

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.

#### a massive zebra

##### Board Regular
In E2: =IF(ISNUMBER(B2),B2,IF(ISNUMBER(C2),C2,D2))

##### New Member
Hi Alan,

This returns a 'VALUE' error for me?

Thanks

##### New Member
Brilliant! Thanks

Replies
8
Views
60
Replies
10
Views
80
Replies
1
Views
33
Replies
0
Views
78
Replies
5
Views
65