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
HIDDEN CELLS IN LIST
-
- 2StarLounger
- Posts: 115
- Joined: 20 Mar 2018, 13:40
Re: HIDDEN CELLS IN LIST
Not sure if the file link came through: https://powerchangeslives-my.sharepoint ... w?e=CbRirn
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: HIDDEN CELLS IN LIST
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.
I have uploaded the imported Excel workbook; let me know when you have downloaded it; I will then remove it.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 115
- Joined: 20 Mar 2018, 13:40
Re: HIDDEN CELLS IN LIST
Hans,
Thank you, it worked. We don't need the other cells, this worked fine.
Penny
Thank you, it worked. We don't need the other cells, this worked fine.
Penny