Excel insert?

[hebronsb]

Is there some way to insert one word into cells that already have a sentence in them?

For example I have thousands of cells with data, but I want to insert the word "alpha" before everyone of those sentences. Does anyone know how to do that in excel or is there a program that can do that?

[hebronsb]

SORRY I figured it out!!!

[Barbarossa]

Are they all in one column?

If so, this will work: (in this example, the text is in column A)

1. Insert a new column.

2. on the first line of the new column, insert the formula

=IF(A1<>"",CONCATENATE("alpha",A1),"")

3. Copy this formula, and paste for the whole column.

4. Now you can copy the new column, and paste-special back to the first column, doing "Values Only".

5. Now you can delete the new column you created in step 1. :)

[Barbarossa]

SORRY I figured it out!!!

Hahaha, I bet it was nothing like my solution huh?

[Rip The Jacker]

SORRY I figured it out!!!
Would you like to post the solution just in case someone else is wondering how?

Also, trashed your other thread. No need to make more than one threads.

[hebronsb]

Excel - Joining Two or More Columns

Although it is usually a good idea to keep data in separate cells - sometimes
you may need to merge columns.

This example supposes you need create a full name from a column of first names
and surnames.

Example
___A____________B_____________C______________________
___Firstname_____Surname_______Fullname
1__John_________Smith________ =CONCATENATE(A1," ",B1)
2__Julie__________Walsh_________Julie Walsh

This is what you do:
1. create a new column after the surname.
2. name the column.
3. in the top data cell type: =CONCATENATE(A1," ",B1)
4. drag the fill down button down for the rest of the data.

The simplest method of joining is =concatenate(A1,B1) but in this case we need
a space.

This method allows to use the joined data and the separate data as the case
requires and is the quickest method available.



THANKS