This is probably a simple question to someone who uses Excel a lot.
Here's the situation...
I'm using Excel2010. I have a spreadsheet with about 4000 rows of serial numbers, short descriptions, etc. One of the columns is image names but without the ".jpg" file extension. I need to add ".jpg" to all 4000 image names in that column. How is this done besides typing it in one image at a time?
If I use Find and Replace then I'll have to do it 36 times to match up with the image names that end in all the different alpha numeric characters. Isn't there a way to add the file extension (or any set of characters) to every string in a column?
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.