Data from 2 cells into one, with specific format

[happydonut]

Hello,

I have this code to add the value from two cells into one;

Range("C1").Value = Range("A1").Value & " " & Range("B1").Value

The cell in A1 has a date, e.g. 2021-01-25
The cell in B1 has a number, e.g. 123456789
Goal is to have the value in C1 as MMDD from cell A1 followed by the value in B1, e.g. 0125 123456789

Questions:
1. How do I format the C1 to get the value there as explained?
2. In real life, there could be many rows in A1 (all dates) and B1 (all numbers). How can I make a code that takes all rows into consideration, e.g. A2+B2=C2, A3+B3=C3 etc until last row with a value?

Thanks.

 

[FormR]

Hi, just obviously use Text rather than Value for the source part, not for the destination …​

Hi, would that change the date in A1 into the required format of MMDD?

The cell in A1 has a date, e.g. 2021-01-25

Goal is to have the value in C1 as MMDD from cell A1

 

[Marc L]

Hi, would that change the date in A1 into the required format of MMDD?

If A1 is yet well formated the cell Text property is the way to go. If not - so I misread - it must be your way …​