+ Reply to Thread
Results 1 to 4 of 4

[SOLVED] how do I put a pasted list into different columns?

  1. #1
    Registered User
    Join Date
    03-28-2011
    Location
    yorkshire
    MS-Off Ver
    Excel 2003
    Posts
    13

    [SOLVED] how do I put a pasted list into different columns?

    Hi,
    I am sure I used to get data copied from somewhere else that consisted of lines of information like this :-

    1. this is a. this is b. this is c.
    2. this is a. this is b. this is c.
    3. this is d. this is e.
    4. this is k. this is l. this is m.

    I did something like a paste special and somehow entered it into excel so that each piece of info was in a separate cell with the 'stop' as the 'separator'.
    I can't see how to do it now? Am I wrong? is there a way?
    thanks,
    Bob.
    Last edited by matelot2; 04-01-2020 at 06:41 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,928

    Re: how do I put a pasted list into different columns?

    You're probably thinking of Data | Text to Columns with the full stop as the separator when you choose Delimited.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    03-28-2011
    Location
    yorkshire
    MS-Off Ver
    Excel 2003
    Posts
    13

    Red face [SOLVED] Re: how do I put a pasted list into different columns?

    Thank you Trevor that is what I was wanting and it works perfectly.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,928

    Re: [SOLVED] how do I put a pasted list into different columns?

    You're welcome. Thanks for the rep.

+ 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. [SOLVED] Turning a pasted list of filepaths into hyperlinks
    By mellenbal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2016, 02:39 PM
  2. [SOLVED] To get url’s from a pasted list of Google
    By ba13 in forum Excel General
    Replies: 1
    Last Post: 05-13-2016, 09:37 AM
  3. Sorrt pasted data into specific columns
    By hassan424 in forum Excel General
    Replies: 2
    Last Post: 07-03-2014, 07:09 AM
  4. [SOLVED] Change order of columns when pasted?
    By cronerd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-23-2013, 06:06 AM
  5. [SOLVED] Help Me Delete a Copy-Pasted Drop-Down List Box
    By TerryS.TX in forum Excel General
    Replies: 1
    Last Post: 07-25-2013, 12:56 PM
  6. [SOLVED] Pasted date in Excel 2003 is wrong e.g. 05-16-2006 is copied,05-15-2002 is pasted
    By Jaap van der Veen in forum Excel General
    Replies: 3
    Last Post: 08-11-2006, 09:10 AM
  7. Replies: 2
    Last Post: 04-04-2006, 08:25 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