Merging 2 Cells without losing content of either. November 11, 2008
Posted by engjake in Uncategorized.Tags: excel tips, merging cells in excel
add a comment
Another trick I learned but then forgot about.
Merging two cells in excel without losing content is pretty easy, but you have to follow a few steps to get it nice and clean if you’re using the final result for a feed into a database or something. I have two cells I am trying to merge the html contents of both into one.
To Combine the Contents:
Column A has content
Column B has content
In column C type the following: =a1&” “&b1
you can then highlight and entire column if you want and paste this and it will combine the contents of column A with Column B and leave a space in between. If you don’t want the space, enter =a1&”"&b1 instead with no space between the quotes.
Adding or appending text to contents of cells. November 11, 2008
Posted by engjake in Uncategorized.Tags: add text, append, Excel
add a comment
Ok, another help article more for myself, but maybe somone else will benefit from this one.
I have a row of data in an excel worksheet. I want to add a file name extention to the contents like .jpg or .gif. Every name is unique so I can’t do a find and replace so how do I add an extension to all of these file names. I figured out a fairly simple solution thanks to a google search so I am recording it here so I can find it again the next time I need to do this.
If you select the entire column, then right click and go to “Format Cells” Select custom at the bottom of the list and then in the text field above the list of custom formating options you can type in @”.jpg” where .jpg is the extention you want to add.
One catch: you can’t insert some pieces of code like “> closing tag instead of the file name. It just doesn’t work for some reason. For this I thought I might add a unique extension like 10005 to the end of every cell and then do a find and replace, but Excel’s find and replace won’t do that for some reason. I’m still looking for the solution to this. I’ve done it before I just can’t remember what I did.
