I am wanting to add the same text to the end of about 10,000 cells, but I don't want to go through and manually type it in on every cell.
So basically, I want to:
A1 A5
text =A1+"file"
textfile
So in cell A5, it would look like "textfile".
That formula is incorrect though, I get #VALUE!
Is there any way I could do this?