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

Hi

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


Arvi Laanemets


"MikeR-Oz" <MikeROz@discussions.microsoft.com> wrote in message
news:7A31513D-0CCC-44F4-B4A9-784869B37E3A@microsoft.com...
> 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
>
>

Thanks Arvi, that is wonderful!!
Mike

"Arvi Laanemets" wrote:

> Hi
>
> =IF(A1="","",A1 & ";" & TEXT(F1,"#0"))
>
>
> Arvi Laanemets
>
>
> "MikeR-Oz" <MikeROz@discussions.microsoft.com> wrote in message
> news:7A31513D-0CCC-44F4-B4A9-784869B37E3A@microsoft.com...
> > 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
> >
> >
>
>
>