•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
how to combine 2 rows into 1 with different formatting.
Our take
Struggling to combine rows with different formatting can be frustrating, especially when your data becomes illegible. If you’re looking to merge a date formatted as "10/02/2026" with a number formatted as "10.552,26" into a single, clear entry, you’re not alone. Fortunately, there’s an efficient way to achieve this without losing clarity. In this guide, we’ll walk you through the steps to seamlessly combine these rows while preserving their unique formats, ensuring your final result is both readable and professional.
i want to combine 1 row thats formatted as date and another that has been formatted as a number. i try using & but it makes the data illegible. if i have 10/02/2026 on row A and 10.552,26 on row b i want the final result to look like 10/02/2026 10.552,26 on row c for example
[link] [comments]
Read on the original site
Open the publisher's page for the full experience