in C1 try

="Hotels New York (Receipt "&COLUMN(B10)&")"

then copy it and paste special as value to B10

if this solution does not suit you then you would need to use a macro


On 17 Sty, 13:48, stew wrote:
Hi All

If I Have a Blank B10 and add text .Can text be added automatically to the
end of that text
ie

"Hotels New York" in *B10
Become
"Hotels New York (Receipt 10)"
and
"Hotels New York" in *B12
Become
"Hotels New York (Receipt 12)"

Thanks For Looking

Stew