Remain the cells data after merge cells

Help Activities
, , , , ,
1

image

Due to the downloaded data weekly , the date is variable - date keep changing.
I had merge cells but not able to remain the data after merge cells . How to solve this issue ?
After merge cells , what should i input in the Cell Text ?

2

@yfbeh Step 1: Open Excel Use Use Excel File (Modern)

Use Use Excel File (Modern)

Step 2: Prepare your date

Create a variable: currentDate = Now.ToString(“dd.MM.yyyy”)

Step 3: Write data BEFORE merge

Use Write Cell (or Write Range if multiple)

Example:

Cell: P1

Value: currentDate

If merging multiple columns (P1), you can also: Write same value in P1, Q1, R1 (optional but safer)

Step 4: Merge cells

Use Merge Cells activity Range: P1:R1

Step 5: Ensure value exists after merge

Use Write Cell again: Cell: P1 (top-left cell of merged range) Value: currentDate

Repeat for other columns-

Example: S1:U1 → next date V1:X1 → next date

Please let me know if it works

3

image
image766×718 35.5 KB

The excel date is varies from the date i downloaded .
I want to keep the Value of the date after merge.

When i insert the Cell Text as DateString . it will appear current date. And it doesnt allow me leave it blank neither .

image
image850×116 4.06 KB

4

@yfbeh Keep Cell Text empty

  • Perform Merge Cells

  • Then use Write Cell to write back the value into the top-left cell (e.g., P2)

This way, the original date is preserved even after merging.