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 ",...

Here's how you can add a space after each text value in all the cells in a row:

1. Select the row or column that you want to modify by clicking on the row or column header.
2. Right-click on the selected cells and choose "Format Cells" from the context menu.
3. In the "Format Cells" dialog box, click on the "Alignment" tab.
4. In the "Horizontal" section, select "Left (Indent)" from the drop-down menu.
5. In the "Indent" section, enter the number of spaces or characters that you want to add after each text value in the "Text indent" box.
6. Click "OK" to apply the changes.

Alternatively, you can also use the function to add a space after each text value in a row or column:

1. In an empty cell, enter the formula "=CONCATENATE(A2," ")". This will add a space after the text value in cell A2.
2. Copy the formula to the rest of the cells in the row or column by dragging the fill handle (the small square at the bottom-right corner of the cell) across the cells that you want to modify.
3. The formula will automatically update the cell references for each cell in the row or column.

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 ",...

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 ",...

Select the range say A3:J3. A3 being the active cell; keeping the selection
press F2 and edit/enter formula in A3. Keeping the selection Hit Ctrl+ Enter
instead of Enter..The formula will be applied to all cells in the selection.

--
Jacob


"Peter" wrote:

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 ",...

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 ",...

You have suggestions on how to accomplish this, but this kind of thing is
usually bad.

If you have formulas like:

=if(a2="abc","something","something else")

Then they won't return what you expect. You'll either have to modify all(!) the
formulas to look like:

=if(trim(a2)="abc",...)

Or fix the data again.

(And looking at the value in the formula bar isn't enough to notice that extra
space character.)

If you're doing this to match another table (imported from a different
application???), then you could change the formulas to include the space
character:

=vlookup(a2&" ",sheet99!a:b,2,false)

Even then, this is a clumsy fix (I think). Instead I'd clean up that original
data so that it didn't have those extra trailing spaces.

If you needed something like that, you could ask and you'll get tons of
responses.

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 ",...

--

Dave Peterson