Insert character at beginning of cell without changing contents
 

How do I insert a character into a cell to repeat for the entire column
without changing the original cell contents?

Answer: Insert character at beginning of cell without changing contents
 

To insert a character at the beginning of a cell without changing its contents, follow these steps:

1. Select the cell where you want to insert the character.
2. Type the character you want to insert at the beginning of the cell.
3. Type the
   Code:

   ---

   =CONCATENATE("X",A1)

   ---

   function in the formula bar, replacing "X" with the character you want to insert and "A1" with the cell reference of the original cell.
4. Press Enter to apply the formula to the cell.
5. Copy the formula to the rest of the column by dragging the fill handle (the small square at the bottom right corner of the cell) down to the last cell in the column.

This will insert the character at the beginning of each cell in the column without changing the original cell contents.

Insert character at beginning of cell without changing contents
 

Insert a new row.

In the first cell of that row: (Assuming you inserted rowA and the old rowA
is now RowB and the letter you want to insert is "P")

="P" & B1

or to insert P_

="P_" & B1

or to insert P with a space

= "P " & B1

Copy down for all rows. Highlight again and copy | paste special | values
and then you can delete row B. You will be left with one row with your first
letter and cell value.

HTH
Thanks,
Roger


"elle" wrote:

How do I insert a character into a cell to repeat for the entire column
without changing the original cell contents?

Insert character at beginning of cell without changing contents
 

Roger means "insert column" when he says "insert row"

In the first cell of that "column" enter ="P" & B1

Rest of it looks good.


Gord Dibben MS Excel MVP

On Wed, 9 Jan 2008 13:46:14 -0800, Roger Converse
wrote:

Insert a new row.

In the first cell of that row: (Assuming you inserted rowA and the old rowA
is now RowB and the letter you want to insert is "P")

="P" & B1

or to insert P_

="P_" & B1

or to insert P with a space

= "P " & B1

Copy down for all rows. Highlight again and copy | paste special | values
and then you can delete row B. You will be left with one row with your first
letter and cell value.

HTH
Thanks,
Roger


"elle" wrote:

How do I insert a character into a cell to repeat for the entire column
without changing the original cell contents?

Insert character at beginning of cell without changing contents
 

Give us an example of what is in the cell and what you want to see displayed

Tyro

"elle" wrote in message
...
How do I insert a character into a cell to repeat for the entire column
without changing the original cell contents?