ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Concatenate text cell and formula cell result (https://www.excelbanter.com/excel-worksheet-functions/211733-concatenate-text-cell-formula-cell-result.html)

GoinCrazy
Concatenate text cell and formula cell result
 
Can I do this:

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

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

I'm trying to result: Books (12345)

porter444
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)

porter444
Concatenate text cell and formula cell result
 
Oops.... forgot the ()

="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)

Teethless mama
Concatenate text cell and formula cell result
 
=CONCATENATE("Books (",COUNTA(G:G),")")


"GoinCrazy" wrote:

Can I do this:

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

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

I'm trying to result: Books (12345)

Gary''s Student
Concatenate text cell and formula cell result
 
="Books (" & COUNTA(G:G) & ")"
--
Gary''s Student - gsnu200816


All times are GMT +1. The time now is 08:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com