Text and Formula in the Same Cell
="ABCD " & countif(A1:A10,"ABCD")
--
Regards,
Tom Ogilvy
"LDanix" wrote in message
...
Hi all!
Is it possible to place text and a formula in the same cell? I have a
column
of people's names. But I would like to add a count of occurences of that
name
in the column. I have successfully been able to do the count in another
cell
but I want the name and the figure in the same cell.
|