Hello,
My Excel file has numbers 1 through 5 (survey answer choices using MS Form Pro). I broke down the answers into several Excel files. However, it seems that all answers with the value of 5 have some ‘hidden quotes’ around them as shown below: I only can see the quotes when I copy and search the value: here I copied the value inside the red box and tried to do ‘find & replace’ with 5 but I kept getting an error(see attachments). How do I get rid of the hidden characters ( quotes in this case)?
Thank you in advance for your help
Hi Fatou,
I don't know why the 5's have an extra character in the data returned by the form. It looks like a CR (carriage return) not quotes. I used CLEAN to remove all non-printable characters and then VALUE to convert that result from text to number
=VALUE(CLEAN('tab1'!B2))
See attached.
Regards
Phil