Results 1 to 5 of 5

Pasting space separated values

Threaded View

  1. #1
    Registered User
    Join Date
    05-09-2013
    Location
    Kansas
    MS-Off Ver
    Excel 2010
    Posts
    3

    Pasting space separated values

    I have some text out of note pad in the following format

    "cat" "dog" "bird" "turtle"
    "cat" "dog" "bird" "turtle"

    There is several lines like this. I need to copy it out of notepad and paste it into excel where every word in quotes is in its own cell. Right now if I paste it everything goes into cell A1.

    Any help would be appreciated.
    I am using excel 2010..
    Last edited by quarinteen1; 05-10-2013 at 12:40 AM.

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