HIDDEN CELLS IN LIST

[COGICPENNY]

I have a downloaded list in .txt (text format) that when previewing shows the email addresses and phone numbers. When I import it, these columns don't show. The deliminator is a %

File: https://powerchangeslives-my.sharepoint ... w?e=CbRirn

Thanks for your help.
Penny

[COGICPENNY]

Not sure if the file link came through: https://powerchangeslives-my.sharepoint ... w?e=CbRirn

[HansV]

The headers stop after column M but the data extend to column X (email address). I don't see a recognizable phone number in the text file.
I have uploaded the imported Excel workbook; let me know when you have downloaded it; I will then remove it.

[COGICPENNY]

Hans,

Thank you, it worked. We don't need the other cells, this worked fine.

Penny