Thread: Concatenate text cell and formula cell result
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
porter444 porter444 is offline
external usenet poster
  
Posts: 73
Default Concatenate text cell and formula cell result
="Books "&COUNTA(G:G)
--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott


"GoinCrazy" wrote:

Can I do this:

=CONCATENATE("Books (",=counta(G:G),x,")")

?????????????????????

I'm trying to result: Books (12345)
Reply With QuoteReply With Quote