Insert character at beginning of cell without changing contents

E

elle

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

Roger Converse

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
 
G

Gord Dibben

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
 
Top