Nov 03 2021 02:38 PM
Hello!
I would appreciate some help turning to traditional values when information was copied and pasted as ref/hyperlink.
I built a new database with the information from a source one. However, during the Crl-C/Crl-V process, it was copied as a ref. Therefore, I can visualize the value, but the actual information is shown as a ref to the other sheet (not valid for data analysis).
I tried to solve on the latest Excel version for Windows on a PC and also using Excel online on a Chromebook, with the same results.
Thank you very much!