+ Reply to Thread
Results 1 to 4 of 4

Add a word to all 400.000 different cells

  1. #1
    Forum Contributor
    Join Date
    11-06-2012
    Posts
    139

    Add a word to all 400.000 different cells

    Hi,

    I have like 400000 cells with different text into it. But i would like to add 1 word to all those 400000 cells.

    Do you have vba-code for this problem.

    Thnx

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Add a word to all 400.000 different cells

    Can you please show some examples of your requirement?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    03-06-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Add a word to all 400.000 different cells

    If it is the same word you need to add and all are in one column, I would recommend putting in a different column

    =CONCATENATE(A1," ","___")

    Where the ___ is you would put your word, then replicate the formula, and copy & paste the values over the top.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

    Re: Add a word to all 400.000 different cells

    Perhaps (not tested)
    VBA for adding specified text at the beginning of each cell

    Please Login or Register  to view this content.
    VBA for adding specified text at the end of each cell

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 02-23-2014, 08:18 AM
  2. [SOLVED] Excel VBA to paste cells & chart to Word table cells
    By CSquared14 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-31-2012, 09:42 PM
  3. [SOLVED] Find cells which contain specific word, delete cells and shift left.
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-24-2012, 07:00 AM
  4. Import cells from excel into word and create multiple word docs
    By scdaddy7269 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2006, 03:03 PM
  5. [SOLVED] Pasting single cells from Word to multiple cells in Excel
    By ASBiss in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-15-2005, 08:06 AM

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