Forum Discussion
Gunner
Mar 02, 2025Copper Contributor
Adding extensions to a column
I need to add a .txt extension to file names in column C. There are 2934 rows in column C. Each file name in column C is different, so I can't just drag the info down. Is there a formula that would solve this problem for me? I sort of got it to work using concatenate, but I had to drag it down and I somehow messed that up.
Any help would be greatly appreciated.
Let's say the file names are in C2:C2935.
In D2, enter the formula
=C2:C2935&".txt"