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.
Bookmarks