Thread: Insert character at beginning of cell without changing contents
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Converse[_2_] Roger Converse[_2_] is offline
external usenet poster
  
Posts: 45
Default 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?
Reply With QuoteReply With Quote