Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default 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?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
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?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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?


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to insert tab character into the cell? kang New Users to Excel 2 July 16th 07 01:01 PM
Add a alphabetic character to the beginning of an entire column of Karise Excel Discussion (Misc queries) 1 August 18th 05 10:24 PM
Identification of "<" character at beginning of cell Hemil Excel Worksheet Functions 3 May 26th 05 07:49 PM
Adding a character to the beginning and end of txt in a cell Duracell Bunnies Excel Worksheet Functions 1 March 18th 05 07:27 PM
only include cells beginning with specified character or number Spunky Excel Worksheet Functions 3 November 23rd 04 05:38 PM


All times are GMT +1. The time now is 02:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"