+ Reply to Thread
Results 1 to 3 of 3

Auto-insert string of words into cells in row

  1. #1
    Registered User
    Join Date
    05-15-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    5

    Auto-insert string of words into cells in row

    Have almost no excel knowledge but I have lots of strings of names in this format:
    "ali bob ann tom dot eva guy ian jak jim joe kay ron kim roy tim"

    Need to insert each line into a row in an excel table but each name needs to be in its own cell
    e.g. (A1) ali (A2) bob (A3) ann .......

    Is there an easy way to do this other than copying and pasting each name into a cell manually.

    Thank you

  2. #2
    Forum Contributor
    Join Date
    12-16-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    109

    Re: Auto-insert string of words into cells in row

    I think that you should copy your names to a text file and then import them as text to Excel

    https://www.youtube.com/watch?v=so2FJFCUUTM

    http://www.easyexcelanswers.com

  3. #3
    Registered User
    Join Date
    05-15-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Auto-insert string of words into cells in row

    I did exactly that and it worked perfectly, thank you

+ 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. Auto Insert Formatted cells below
    By mateow20 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-17-2015, 12:20 AM
  2. String Code that imports words from other cells
    By forestavekids in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-10-2015, 02:19 PM
  3. Replies: 15
    Last Post: 10-12-2014, 08:53 AM
  4. [SOLVED] Extract all the words from a string for processing, while leaving string intact.
    By staggers47 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-10-2014, 02:02 PM
  5. Replies: 1
    Last Post: 07-02-2014, 12:02 PM
  6. Complex VBA problem auto insert date and time, auto insert comment, etc.
    By rojashan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2013, 09:40 PM
  7. Replies: 0
    Last Post: 06-08-2005, 07:05 PM

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