adding text to a column of exsisting data

[Guest]

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

 

[Guest]

Hi
Use a helper column alongside your data:
="This bit first "&A2&" and then this"
Fill this down the column. Once you are happy with it, copy the range and
then Edit|Paste Special|Values to fix the values in place

 

[Guest]

If I understand right, I suggest using the concatenate function.
If data is in C1:C50, put "=concatenate("beginning text",C1,"ending text")"
in row 1 of a blank column. Copy the formula down for all 50 rows. Then
copy, paste special (value) back into column C. Delete the column you
created.
- Will

 

[Guest]

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