Hi - try putting this into cell G2
You can use a combination of cell references (C2, D2, E2) and literal text, which goes in quotation marks (" - "). Seperate each token with an ampersand.![]()
=C2 & " - "& D2 & ", " & E2 & " Rental Months Remaining"
If that works, you can just drag the formula down to the end of your range.
Good luck!
Bookmarks