What does =" mean

[pcrowley]

I have a spreadsheet where the column headers are in row 2. Several of the headers have =" preceding the header. For example ="Question is I one column. The =" is only visible in the formula window. The cell itself displays the header followed by a number. I was told the number is the number of non-blank cells in the column. This doesn't seem true because one column has the number 25 when there are actually 27 non-blank cells, plus the header.

Can anyone tell me what the =" does?

Thank you!

 

[gruntingmonkey]

Does it end in " too? If so, it could mean that there is a calculation in the cell. Can you paste an entire cells details?

 

[pcrowley]

No, it does not end in "

I don't seem to b able to paste an image of the cell. The formula window reads:

="Question

The cell displays:

Question
25

 

[Norie]

What happens if you increase the height of the formula bar by dragging down it's bottom border?

 

[Special-K99]

FYI

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[sandy666]

look at post#4

 

[pcrowley]

That is it! When I drag the formula bar down I get:

="Question&COUNTA(N7:N998)

Now I understand, it is counting non-blank cells between row 7 and row 998.

Thank you all so much for the help!