Printable View
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?
SORRY I figured it out!!!
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. :)
Hahaha, I bet it was nothing like my solution huh?Quote:
Originally Posted by hebronsb
Would you like to post the solution just in case someone else is wondering how?Quote:
Originally Posted by hebronsb
Also, trashed your other thread. No need to make more than one threads.
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