View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.