So you want to merge cells without losing data. You've probably tried the "Merge Cells" button, but you get a warning message that "Merging cells only keeps the top left value and ignores other values." So what do you do? YOU ?
This video examines two solutions. The first solution merges cells without using a formula, it does it using Flash Fill. The second solution merges cells using a concatenation formula. If you concatenate date values, by default the date becomes a number and if you concatenate a currency value, by default you will lose the currency format. This video shows you how to fix both of these formatting issues.
Contents:
00:00 – Presentation
00:25 – Solution 1: Merge cells without formula
01:23 – Solution 2: Merge cells with formula
02:15 – Concatenating a date becomes a number
03:46 – Concatenate – keep currency format
——————–
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments