Your Ad Here Your Ad Here
Results 1 to 6 of 6

Thread: Excel insert?

  1. #1
    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?

  2. Software & Hardware   -   #2
    SORRY I figured it out!!!

  3. Software & Hardware   -   #3
    Barbarossa's Avatar mostly harmless
    Join Date
    Jun 2002
    Location
    Over here!
    Posts
    19,631
    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.

  4. Software & Hardware   -   #4
    Barbarossa's Avatar mostly harmless
    Join Date
    Jun 2002
    Location
    Over here!
    Posts
    19,631
    Quote Originally Posted by hebronsb
    SORRY I figured it out!!!
    Hahaha, I bet it was nothing like my solution huh?

  5. Software & Hardware   -   #5
    Rip The Jacker's Avatar Retired
    Join Date
    Nov 2002
    Location
    Los Angeles, CA
    Age
    31
    Posts
    6,435
    Quote Originally Posted by hebronsb
    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.

  6. Software & Hardware   -   #6
    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

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •