Insert character at beginning of cell without changing contents

  • Thread starter Thread starter elle
  • Start date Start date
E

elle

How do I insert a character into a cell to repeat for the entire column
without changing the original cell 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
 
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
 
Inserting without changing contents of cell

I'm inserting text at the beginning of a cell and inserting the contents of another cell after that.

I know this is super easy but I can't seem to get it right...here is my formula:

="PINEWOOD DERBY " & D9 & B9
Here is how it reads:
PINEWOOD DERBY RMXY9605CHASSIS WEIGHTS
I'm trying to get a space to print after the contents of d9. So a space between the RMXY9605 and CHASSIS.
Thanks!
 
Back
Top