+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 : How to add the same text to multiple cells with preexisting text

  1. #1
    Registered User
    Join Date
    12-20-2009
    Location
    seattle, wa
    MS-Off Ver
    Excel 2003
    Posts
    2

    How to add the same text to multiple cells with preexisting text

    Hello ,

    Here is my issue:

    I have a list of SKUs in Excel and I need to add one same word to 500 cells that have pre-existing text in the cells. See example below:

    1) List of SKU's in cells:

    34
    35
    39
    55


    2) text that needs to be added IN FRONT of every number:

    DF

    So the result would be:

    DF34
    DF35
    DF39
    etc.

    How do I do that in a formula and not manually? I found another similar thread and I understand how to do it from the instructions there but the same text goes on the back and the result is: 34DF but I need it to be like: DF34.

    I am using Office 2007 for mac.

    Thank you for the help,
    Chris

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: How to add the same text to multiple cells with preexisting text

    Hi chris_ks

    welcome to the forum. Without seeing your workbook layout, I suggest these steps using a temporary helper column

    - to the right of the column with your SKUs, insert a new column, unless it is already an empty column.
    - enter this formula into the first row of the new column

    ="DF"&A1

    - If your SKUs are not in column A, change the A1 to the respective column letter.
    - copy this forumula down to the row with the last SKU
    - copy the whole column with the formula
    - select the column with the SKUs and click Edit - Paste Special - Values
    - finally, delete the helper column.

    hth

  3. #3
    Registered User
    Join Date
    12-20-2009
    Location
    seattle, wa
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: How to add the same text to multiple cells with preexisting text

    Thank you very much teylyn,

    It worked! It was easy and painless.

    Chris

  4. #4
    Registered User
    Join Date
    07-01-2014
    Location
    Rotterdam, Netherlands
    MS-Off Ver
    14.4.2
    Posts
    1

    Re: How to add the same text to multiple cells with preexisting text

    Quote Originally Posted by teylyn View Post
    Hi chris_ks

    welcome to the forum. Without seeing your workbook layout, I suggest these steps using a temporary helper column

    - to the right of the column with your SKUs, insert a new column, unless it is already an empty column.
    - enter this formula into the first row of the new column

    ="DF"&A1

    - If your SKUs are not in column A, change the A1 to the respective column letter.
    - copy this forumula down to the row with the last SKU
    - copy the whole column with the formula
    - select the column with the SKUs and click Edit - Paste Special - Values
    - finally, delete the helper column.

    hth
    Hi,

    I just registered only to say thank you for this simple but amazing solution!

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Excel 2007 : How to add the same text to multiple cells with preexisting text

    Please Login or Register  to view this content.
    and if the values go above 100, you could use this one:

    ="DF"&text(a1,"000") and drag down.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1