We'd like to remind Forumites to please avoid political debate on the Forum... Read More » This is to keep it a safe and useful space for MoneySaving discussions. Threads that are - or become - political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

The Forum is currently experiencing technical issues which the team are working to resolve. Thank you for your patience.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Raisin - Download transactions - Help needed, bit of a techie question

Comments

Sea_Shell Posts: 9,996 Forumite

28 August 2024 at 2:12PM

Exodi said:

Open Excel and click 'Text to Columns' under the 'Data' tab.

Click Delimited, check 'Semicolon', then click finish. Using your examples above it displays fine on my end.

If you want to remove speech marks, you could just CTRL+F, click the 'Replace' Tab and under 'Find what:' enter "
and under Replace with leave it totally blank (not even a space).

Just tried it your way, and that works perfectly, thanks. The spurious " disappear too.

I realised that (after a little play around) you have to highlight column A first (where all the text is), and then use the "text to columns" button.

I can then just add filters and change the column widths to my liking.

Sorted.

How's it going, AKA, Nutwatch? - 12 month spends to date = 2.60% of current retirement "pot" (as at end May 2025)
2

★ ★ ★ Meet your Ambassadors

Confirm your email address to Create Threads and Reply

MSE News

Lloyds, Halifax and Bank of Scotland to cut overdraft rates for millions but hike them for others – here's what's happening and full help
If you're a Lloyds, Halifax or Bank of Scotland current account holder, the interest rate you're charged for using your overdraft could change soon as part of a fees shake-up. The Lloyds Banking Group, which owns all three brands, says millions of its customers will pay less after the changes – but a "few" will pay more.
Warm Home Discount expansion confirmed with millions more eligible for the £150 top-up this winter – here's what we know
Around 2.7 million more low-income households, including 900,000 families with children, will become eligible for the £150 Warm Home Discount this winter, as the Government has confirmed it will remove the existing 'hard to heat' eligibility criteria. The extension has only been confirmed for winter 2025/26, with further changes possible for future years.
Martin Lewis: At last a chance to fix Council Tax flaws impacting millions – debt collection, difficulty challenging your band, discounts and more
Major flaws in the Council Tax system in England could finally be fixed in future, as the Government has launched a wide-ranging consultation to review hideous debt collection practices, the difficulty of challenging your band, the overly complex and horribly-named Severe Mental Impairment discount and more. MoneySavingExpert.com founder Martin Lewis, who has long campaigned on these issues, shares his response and analysis.
Energy complaints to be dealt with more quickly and Energy Ombudsman to get new powers under Government plans
If you have a complaint about your energy firm, it may be resolved more quickly in future, as the Government has announced a raft of proposals to strengthen consumer protections in the energy market. The planned changes include giving the Energy Ombudsman new powers to force firms to comply with its decisions – but it's still very early days. Here's what we know so far.
Warm Home Discount expansion confirmed with millions more eligible for the £150 top-up this winter – here's what we know
Around 2.7 million more households, including 900,000 families with children, will become eligible for the £150 Warm Home Discount this winter, as the Government has confirmed it will remove the existing 'hard to heat' eligibility criteria. The extension has only been confirmed for winter 2025/26, with further changes possible for future years.
Base rate held at 4.25% – here's what it means and when it might be cut next
The Bank of England has held the base rate at 4.25%. Below we explain why, when it might be cut, plus what it means for your mortgage and savings.
Applied for South West Trains 'boundary fares' compensation? Act now to claim it
If you applied for compensation from South West Trains before the deadline in January 2025, you now need to provide your bank details to the claim administrator so it can be paid to you. Here's what you need to know.
Winter Fuel Payments to be reinstated for millions – Martin Lewis explains how it'll work, what it means and if it's an improvement
All State Pensioners in England and Wales will receive a Winter Fuel Payment this winter, though those who earn over £35,000 will see it clawed back through the tax system. It means nine million pensioners will get the £200 or £300 top-up. Here MoneySavingExpert.com founder Martin Lewis shares his instant response and analysis, and we include answers to your key questions.
Winter Fuel Payments to be reinstated for millions – Martin Lewis explains how it'll work, what it means and if it's an improvement
All State Pensioners in England and Wales will receive a Winter Fuel Payments this winter, though those who earn over £35,000 will see it clawed back through the tax system. It means nine million pensioners will get the £200 or £300 top-up. Here MoneySavingExpert.com founder Martin Lewis shares his instant response and analysis, and we include answers to your key questions.

View All

Raisin - Download transactions - Help needed, bit of a techie question

Comments

Confirm your email address to Create Threads and Reply

🚀 Getting Started

Categories

Is this how you want to be seen?

Get our FREE Weekly email full of deals & guides - and it’s spam-free