Forum Discussion

Gunner's avatar
Gunner
Copper Contributor
Mar 02, 2025

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"

Resources