More tutorials and posts can be found at http://www.TheVirtualAsst.com.
Ever wanted to combine data in two separate cells into one in Excel? (e.g. First Name and Last Name) This video tutorial will explain how to combine the data from those two cells into one and then how to keep that data constant so when the referenced cells are deleted you still have your desired data.
@danysheun Ah, correct, it is not a paranthesis but quotation marks like this " and there is a space between~ example: A2&” “&B2
The full instructions on my blog may be helpful as well.
YVAmmangen 4 months ago
I'm guessing when you were reading the formula you meant to say double quotation marks, not parenthesis.I tried the parenthesis and it didn't work.Thanks for the video though.It helped a lot.
danysheun 4 months ago