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 s...
HansVogelaar
Mar 03, 2025MVP
Let's say the file names are in C2:C2935.
In D2, enter the formula
=C2:C2935&".txt"