Is there some way to affix a predefined bit of text or number or something to the end of a particular cell?
For instance, I have a spreadsheet that has about 50 rows, and about 5 columns. One of the columns will always be a photo name including the extension, which is always .jpg (in this instance). I'd like to be able to predefine somewhere in this column that the suffix is always ".jpg" so that whatever I type will then be outputted with the extension included. Thus, when I enter "filename" it will show up as "filename.jpg" ....
Thanks!
Bookmarks