+ Reply to Thread
Results 1 to 4 of 4

Paste Problems

  1. #1
    Registered User
    Join Date
    02-03-2009
    Location
    New Jersey
    MS-Off Ver
    Excel 2003
    Posts
    8

    Paste Problems

    Here's a dumb question. For some reason when I copy a text line from another program and try to paste it into excel, each word is pasted into the next cell on that row and not all in the same cell. For example: I'll copy an address 123 Fake St. (no enter characters), and it pastes "123" in cell A1 "Fake" in A2 and "St." in A3. It always pasted into one cell before and dont know how a setting changed or how to change t back. I remember this happened once before and I fixed it, but cannot remember for the life of me how I did it. Any suggestions?

  2. #2
    Registered User
    Join Date
    09-11-2008
    Location
    CO
    MS-Off Ver
    Office 2007
    Posts
    40

    Re: Paste Problems

    Instead of just pasting, right click & Paste Special. Select "Text" and hit okay, and that should do it.

  3. #3
    Registered User
    Join Date
    02-03-2009
    Location
    New Jersey
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Paste Problems

    Tried that and it didn't work. But colsing and reopening Excel seemed to fix it. Guess it was just some kind of glitch.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Paste Problems

    If you do text to columns, Excel retains the parameters last used for splitting text and will apply it automatically the next time you paste text.

    You can reset the behavior in VBA.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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