• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel Spreadsheet question..

T

Tavis

Senior member
Does anyone know if there is a way to merge two cells together and keep the text that is in both of the cells? When I try to merge them normally, it only keeps what is in the left cell.

Any help appreciated.
 
Your best bet is to probably write a formula to concatenate the two cells.

ie: =concatenate(A1," ",B1)
 
Hrmm... another question on the same topic.. How can I get each cell to combine with the two cells before it without having to manually type each formula in? Example:

Cell 1 | Cell 2 | Cell 3

Row A abc | 123 | =A1&B1 - which of course we know equals abc123
Row B abd | 321 | = - if i put the same forumla in row b, it will only do cell one and cell 2 from Row A, but I want it to do Row B with the same formula, just with B1&B2..

So my question is, how do I make each formula be just for that row without having to manually enter the formula for each row. Thank you for any assistance!
 
You don't have much experience with Excel, do you? 😉

Select the cell in ROW A that has the formula. It will highlight and in the lower right corner you'll see a small black square. Drag that black square down as many rows as you need. Excel will adjust the references in the formulas for you.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top