Click on the first cell that you want to combine.In the cell where you’d like to see the combined values from two other cells: That’s a savings of 10 characters!Īnd in the hot weather we’re having this summer, it’s important to conserve your energy for more important things.Įven more good news - you don’t need to remember how to spell “ampersand”, and you can even use one of its less technical names - “Fancy And” or “Shift-7”. Yes, instead of using CONCATENATE, you can use the ampersand operator - & - to combine cell values in Excel. Keep reading, to learn the easy way to combine cells, and add some fancy formatting to the dates and numbers. You can combine cells in Excel, without CONCATENATE function. Good news, if you’re spelling challenged - or too lazy to type long words.
0 Comments
Leave a Reply. |