+ Reply to Thread
Results 1 to 3 of 3

copy and paste problems

  1. #1
    Registered User
    Join Date
    05-29-2010
    Location
    Stoke-on-Trent, England
    MS-Off Ver
    Excel 2007
    Posts
    1

    copy and paste problems

    Hi,

    I was very happy copying and pasting my bank statements onto a 2003 Excel spreadsheet - so I can keep good records for business. I used to highlight a section of my bank statement, say 6 rows x 5 columns, copy it, then paste into 2003 Excel - no problem. The data would appear in the right cells - 6 rows x 5 columns.

    Now I’ve started to use 2007 Excel. When I try to paste the same data into a 2007 spreadsheet it populates just the first column. I get all my data in column A. I've tried Paste Special - no joy. I don't know what to do or if anyone else has this problem? It's making my work really hard and very time consuming.

    I've tried to copy by using [ctrl][c][c] to using to office clipboard - but no joy.
    I've tried to use the Data tab in Excel, then Text To Colunms, then i've played around with the options - still no joy!

    Any help would be a life saver!

    Thanks a lot

    Paul

    p.s. here is as sample of how the data i'm trying to copy and paste:

    02 Jun VIS CO-OP GROUP 109224
    PRINCESS PARK
    16.02 230.86
    01 Jun BP BRIAN BURTON
    KATHERINEWATERBILL
    280.00 246.88
    01 Jun VIS SWIFTCOVER.COM
    08712714011
    87.96 526.88
    30 May ATM CASH CO-OP MAY30
    COOP LAWTON @09:56
    300.00 614.84

    This data should be 6 colunms x 4 rows.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: copy and paste problems

    Please read the Forum Rules,I have edited your Thread Title to remove unnecessary wording - see Rule #1. This is an excel vforum so there is no need to put Microsoft excel in the title
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: copy and paste problems

    I've seen this before, too. Interestingly, Excel seems to use the settings from the LAST time you used the Text To Columns feature when you paste data in from the clipboard. I find that very odd, but at least it's manageable.

    So, paste anything into a cell in column A. Then select it, then use:
    Data > Text To Columns > Delimited > Tab > Finish

    Now, try pasting in your data from the other source, perhaps better results?
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

+ Reply to Thread

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