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