software

I have a cell that has a name e.ggt;gt; A1 = POW
I have another cell which is a number derived from a formula drawn from
other cells e.g.gt;gt;gt; 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
Hi

=IF(A1=quot;quot;,quot;quot;,A1 amp; quot;;quot; amp; TEXT(F1,quot;#0quot;))Arvi Laanemetsquot;MikeR-Ozquot; gt; wrote in message
...
gt; I have a cell that has a name e.ggt;gt; A1 = POW
gt; I have another cell which is a number derived from a formula drawn from
gt; other cells e.g.gt;gt;gt; D1=5 , E1 =3 Cell F1 = (E1/D1)*100 which happens to
be
gt; 60
gt;
gt; I now want to have a cell say F6 to pick up the word/text in A1 and then
add
gt; some extra words /symbols so that I get a cell that reads:-
gt;
gt; POW;60
gt;
gt; How do I do This??
gt;
gt; Thanks
gt; Mike
gt;
gt;
Thanks Arvi, that is wonderful!!
Mike

quot;Arvi Laanemetsquot; wrote:

gt; Hi
gt;
gt; =IF(A1=quot;quot;,quot;quot;,A1 amp; quot;;quot; amp; TEXT(F1,quot;#0quot;))
gt;
gt;
gt; Arvi Laanemets
gt;
gt;
gt; quot;MikeR-Ozquot; gt; wrote in message
gt; ...
gt; gt; I have a cell that has a name e.ggt;gt; A1 = POW
gt; gt; I have another cell which is a number derived from a formula drawn from
gt; gt; other cells e.g.gt;gt;gt; D1=5 , E1 =3 Cell F1 = (E1/D1)*100 which happens to
gt; be
gt; gt; 60
gt; gt;
gt; gt; I now want to have a cell say F6 to pick up the word/text in A1 and then
gt; add
gt; gt; some extra words /symbols so that I get a cell that reads:-
gt; gt;
gt; gt; POW;60
gt; gt;
gt; gt; How do I do This??
gt; gt;
gt; gt; Thanks
gt; gt; Mike
gt; gt;
gt; gt;
gt;
gt;
gt;