I have two separate columns on a sheet, Year and Airplanes. I want to make a second sheet that takes these two numbers and puts them into ONE CELL, Year - Airplane Qty. How do I do it?
I have two separate columns on a sheet, Year and Airplanes. I want to make a second sheet that takes these two numbers and puts them into ONE CELL, Year - Airplane Qty. How do I do it?
It would just be:
In column three or on the next sheet, type:
=A1&" - "&B1
you can join two cells together using an &. And if you want to put any text between the two cells you are joing, use "text" with &'s on either side of the quote marks as above.
If that's what you were after....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks