Mar 05 2019 05:08 AM
Hi!
I have just contacted Microsoft support, who directed me here.
I am trying to create a custom list across colums so each cells value is linked with its adjacent cell i.e. A1 and B1, A2 and B2, A3 and B3 etc...
the idea being when one of these values appear, I can click and drag to reveal their counterpart.
When I try to create a custom list, I get an error message saying "Cells without simple text were ignored" and nothing gets imported as a list...any way around this? I have tried to change the format to "text", "number" and "general" in the home tab but does not resolve the issue.
Thanks in advance!! :)
Mar 05 2019 06:59 AM
SolutionMar 05 2019 07:26 AM
Thanks for the response!
Unfortunately none of the cells contain formulas :(
I'm linking an address ID (numerical) with and address in text?
Thanks again!
Oct 30 2022 10:33 PM
Feb 20 2024 05:59 AM
@Jan Karel Pieterse What fixed this for me was copying my list into notepad and then pasting from there into the list entry box
Mar 05 2019 06:59 AM
Solution