Either:
Copy, select your range on the sheet, Paste,
or
Copy, type the reference of your range into the name box, Paste,
or
Click on the bottom right hand corner of the cell to get a square fill
handle, then drag that across your range,
or ...
--
David Biddulph

"Peter" wrote in message
...
Thanks. Is there a way to copy the formula (=a2&" ") into all the cells
or
range of cells in a row instead of copying the formula into one cell at a
time?

"Access Noob" wrote:

try going to an empty part of the sheet (say row a4) & type =a2&" " or
"[any
character]" then copy that across the row for your range. after calc you
can
copy the range & paste special (values) back into range a2 ...X2 & your
titles will have a trailing space [any character].

"Peter" wrote:

I want to add a space (or any character(s)) after each text value in
all the
cells in a row or in a column

For example, cell A2 contains "ABC", cell B2 contains "DEF", and so on.
I
want to make all the cells in row 2 to have a space so cell A2 contains
"ABC
", cell B2 contains "DEF ",...