Need help with data exported from a database program.

New Contributor

22 January 2020 Slindile Mngadi: TRACER PAID

29 July 2022 Import: Monthly Debit Order 7 / 33 Of 308.49On 2022/04/29 Paid 2022/04/30

30 July 2022 Import: Monthly Debit Order 8 / 33 Of 308.49On 2022/06/01 Paid 2022/06/01

30 July 2022 Import: Monthly Debit Order 3 / 33 Of 308.49On 2022/01/03 Failed Funds 2022/01/10

30 July 2022 Import: Monthly Debit Order 4 / 33 Of 308.49On 2022/02/01 Failed Funds 2022/02/08

 

The top is data that were exported from a database program into excel. All the data were exported into one cell. I am looking for a solution to place each row of information into a different cell. the 

 

Is this possible. I tried data, text to column.

2 Replies

Hi @Chrisjvr ,

 

Could you please attach the same file with a few records, I need to understand the data

 

Regards, Faraz Shaikh 

@Faraz Shaikh 

How do I attach the exel file.

 

Regards