Donate SIGN UP

Formula In Spreadsheet

Avatar Image
andy-hughes | 10:38 Sun 28th Jun 2020 | Technology
11 Answers
I'm back again, thought my issue was solved, but no such luck!

I have a huge basic Excel database with my record collection listed, and somehow a formula has got into it that prevents me from putting it in alphabetical order.

I have right-clicked and can't see any obvious indications of a formula - can anyone help me to find what the formula is, and get rid of it.

Thanks.
Gravatar

Answers

1 to 11 of 11rss feed

Best Answer

No best answer has yet been selected by andy-hughes. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
I don't see how anyone can find the formula without seeing the relevant spreadsheet. But you could use the option to "show formulas" -- go to the formulas tab and it should be there as an option. That will make it so that the formula in each cell, rather than the result, is shown.
Have you tried Data > Sort?
Can't you just copy and save as "values" or "text"
^^"paste" as
Question Author
I have narrowed it down to the 'I' section - I'm, I'd, I'll - could there be something in the apostrophe that's jamming things up?
Save a copy and try removing the apostrophe in the copy.
Question Author
Edmund - // Save a copy and try removing the apostrophe in the copy.//

I could do that, but I'd rather find the glitch and remove it, to stop it cropping up again.
Have you used a 1 instead of an I ?
Question Author
JJ - // Have you used a 1 instead of an I ?//

No - every entry is an 'I'.
Are there extra spaces before the "I" or after the "I'"?
Question Author
I have fixed it!!

I remembered importing some of the entries from a specific list, and that's where the formulas could be located. I took those entries out and re-typed them, re-alphabeticised, and it's all good.

Thanks everyone for your patience and input, much appreciated - again!!

1 to 11 of 11rss feed

Do you know the answer?

Formula In Spreadsheet

Answer Question >>