Copied some data from pdf document into excel.
Now I want to extract a phone number in the first 10 characters.
So I go =left(a1,10) but it comes up with an error
the message is meaningless as it just says error.
If I just go =left(a1) it extracts the first character as it should.