RE: adding text to a column of exsisting data
- From: "Duke Carey" <DukeCarey@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 24 May 2005 08:58:14 -0700
Make changes on a copy of your file, not the original!!!
If you want to add numeric data to numeric data, such as increasing every
entry in a column of numbers by 100:
place 100 in an empty cell & copy it
select all the numbers to be changed
use Edit>Paste Special> & click on Values and on Add
click on OK
If you want to add character data to an existing cell entry, use the formula
="new characters"&existing or
=existing&"new characters"
then copy all the formulas
select the original text
use Edit>Paste Special>Values to replace the original text
"Dalerj70" wrote:
> I am trying to add data (same value) to exsisting cells at the beginnning and
> also the end in one column that has different values in each cell. I want to
> this so I dont have to do manually
>
> Thanks
.
- References:
- adding text to a column of exsisting data
- From: Dalerj70
- adding text to a column of exsisting data
- Prev by Date: how to automatically color a cell
- Next by Date: Re: how to automatically color a cell
- Previous by thread: RE: adding text to a column of exsisting data
- Next by thread: what is the formula to add totals from two different worksheets
- Index(es):
Relevant Pages
|
