Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How do I insert a character into a cell to repeat for the entire column
without changing the original cell contents? |
#2
![]() |
|||
|
|||
![]()
To insert a character at the beginning of a cell without changing its contents, follow these steps:
This will insert the character at the beginning of each cell in the column without changing the original cell contents.
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to insert tab character into the cell? | New Users to Excel | |||
Add a alphabetic character to the beginning of an entire column of | Excel Discussion (Misc queries) | |||
Identification of "<" character at beginning of cell | Excel Worksheet Functions | |||
Adding a character to the beginning and end of txt in a cell | Excel Worksheet Functions | |||
only include cells beginning with specified character or number | Excel Worksheet Functions |