CELL that picks up or inserts text with formula
 

I have a cell that has a name e.g A1 = POW
I have another cell which is a number derived from a formula drawn from
other cells e.g. D1=5 , E1 =3 Cell F1 = +(E1/D1)*100 which happens to be
60

I now want to have a cell say F6 to pick up the word/text in A1 and then add
some extra words /symbols so that I get a cell that reads:-

POW;60

How do I do This??

Thanks
Mike

CELL that picks up or inserts text with formula
 

Hi

=IF(A1="","",A1 & ";" & TEXT(F1,"#0"))


Arvi Laanemets


"MikeR-Oz" wrote in message
...
I have a cell that has a name e.g A1 = POW
I have another cell which is a number derived from a formula drawn from
other cells e.g. D1=5 , E1 =3 Cell F1 = +(E1/D1)*100 which happens to
be
60

I now want to have a cell say F6 to pick up the word/text in A1 and then
add
some extra words /symbols so that I get a cell that reads:-

POW;60

How do I do This??

Thanks
Mike

CELL that picks up or inserts text with formula
 

Thanks Arvi, that is wonderful!!
Mike

"Arvi Laanemets" wrote:

Hi

=IF(A1="","",A1 & ";" & TEXT(F1,"#0"))


Arvi Laanemets


"MikeR-Oz" wrote in message
...
I have a cell that has a name e.g A1 = POW
I have another cell which is a number derived from a formula drawn from
other cells e.g. D1=5 , E1 =3 Cell F1 = +(E1/D1)*100 which happens to
be
60

I now want to have a cell say F6 to pick up the word/text in A1 and then
add
some extra words /symbols so that I get a cell that reads:-

POW;60

How do I do This??

Thanks
Mike