Forum Discussion

Copper Contributor

Apr 11, 2022

How to copy transaction from credit card statement with the help of power query or any new method

Hi Community, The transactions i copied from statement are pasted in one cell. How can we split the content as per the format included in attached file with the help of power query or any other ...

Bank statement format query.xlsx9 KB

excel

Formulas and Functions

Copper Contributor

Apr 11, 2022

Riny_van_EekelenThe statement is in PDF format.

And i currently use 2016 version which do not give excess to connect with PDF under Get data Tab.

Riny_van_Eekelen

Platinum Contributor

Apr 11, 2022

SAKSHI_ROY I see. Then it's going to be difficult as there are no consistent delimiters to separate the transactions.

SAKSHI_ROY
Copper Contributor
Apr 11, 2022
Riny_van_EekelenI will look at some other trick ans share with you.
Thanks for your concern and time invested on my query.