Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel: add & propogate an extension to an existing filename

Jul 24, 2004 2:19AM PDT

How do I add and propogate an extension to a column in MS Excel?

Example: I have a column of different usernames but want to add the extension, .jpg, to the usernames in that column?

Thanks.

Discussion is locked

- Collapse -
Re: Excel: add & propogate an extension to an existing filen
Jul 24, 2004 2:49AM PDT

Just wanted you to know that there are about 17k filenames to add the .jpg extension to.

Not sure what the formula is to do that.

- Collapse -
Re: Excel: add & propogate an extension to an existing filen
Jul 24, 2004 3:12AM PDT

I have a partial answer, but the issue is you want to alter the original column. For that I would use VBA code. If you wanted to place the result in a new column, then just look up string functions.

Bob

- Collapse -
Re: Excel: add & propogate an extension to an existing filen
Jul 24, 2004 6:00AM PDT

Assuming you want to take a text value (such as a username) in cell B2, you would put in the new cell:
=CONCATENATE(B2,".jpg")

So if B2 has Thomas in it
and in cell D2 you place that formula,
you would result with:
Thomas.jpg