Concatenate ?

P

Paul Watkins

Hi
I have a sheet with data in 3 columns (A,B & C). and Ten Rows (1 to 10).In
column D i have this formula '= CONCATENATE (A1,B1,C1)'

Normally in Row 1, only one column would have any text in it (could be a, b
or c) hence the formula.(Row 2 etc the same)

Is there a way of building on the formula/ Vb code, that would display the
cell that the text was in

e.g

Out of the three columns (A,B & C) there was a text entry in Cell B1. I
would like to display in E1, that cell address e.g 'B1' or better still,
just the column 'B'

Thanks in advance

Paul
 
K

kkknie

Here's a quick formula. It's not very robust (i.e. you will have t
change it if you use other than the A, B and C columns).

=IF(ISTEXT(A1),"A",IF(ISTEXT(B1),"B",IF(ISTEXT(C1),"C","No Text")))
 
P

Paul Falla

Dear Paul
Try the following formula. Enter it into cell E1, and then
copy it down as many rows as necessary.
=IF(A1<>"","A",IF(B1<>"","B","C"))

Hope this helps

Paul Falla
 
A

Arkimediz

How about formula for E1 as

=IF(A6>"","A",IF(B6>"","B",IF(C6>"","C")))

It returnes FALSE if all cells are blank or a number is
put in but works for text.

Arkimediz
 
A

Arkimediz

I don't like using Concatenate -

= CONCATENATE (A1,B1,C1) is the same as = A1 & B1 & C1
 
P

Paul Watkins

Thanks for all the replies
They work

Paul
Arkimediz said:
I don't like using Concatenate -

= CONCATENATE (A1,B1,C1) is the same as = A1 & B1 & C1
Click to expand...
 
Top