Marco date/text

[graiggoriz]

Hello,

I need to add text + day in a cell and being able to keep on editing the cell.

for example: If I am in the cell A3 I would like to run a macro and have in this cell with the following tag: "GG: 11/01" (the 11/01 is dd/mm) and then being still able to add text ("GG: 11/01" blablabla)


Thanks,
Graig

[FDibbins]

Why not do that in 2 cells? Have your text in 1 cell, and in the next, combine that with your date?
Something like
A1=your entered text blabla
B1="GG : text(today(),"dd/m")&" "&A1

[graiggoriz]

Thanks Ford!! I did not do it in 2 cells as it regards follow up on projects.

In the same cell I put:
"GG: 07/01 We face a problem with the application.
GG: 11/01 A technician has fixed application and the print function.
GG: 13/01 The report issue is fixed."

So in above example, I would run the macro 3 times. (the macro would only add the atg and date: "GG: 07/01" + "GG: 11/01" + "GG: 13/01"

I really do not know if this is possible! Any help would be really appreciate.

thansk,
Graig