Turn to real values when copied as ref - hyperlinks

%3CLINGO-SUB%20id%3D%22lingo-sub-2923779%22%20slang%3D%22en-US%22%3ETurn%20to%20real%20values%20when%20copied%20as%20ref%20-%20hyperlinks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2923779%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3EI%20would%20appreciate%20some%20help%20turning%20to%20traditional%20values%20when%20information%20was%20copied%20and%20pasted%20as%20ref%2Fhyperlink.%3C%2FP%3E%3CP%3EI%20built%20a%20new%20database%20with%20the%20information%20from%20a%20source%20one.%20However%2C%20during%20the%20Crl-C%2FCrl-V%20process%2C%20it%20was%20copied%20as%20a%20ref.%20Therefore%2C%20I%20can%20visualize%20the%20value%2C%20but%20the%20actual%20information%20is%20shown%20as%20a%20ref%20to%20the%20other%20sheet%20(not%20valid%20for%20data%20analysis).%3C%2FP%3E%3CP%3EI%20tried%20to%20solve%20on%20the%20latest%20Excel%20version%20for%20Windows%20on%20a%20PC%20and%20also%20using%20Excel%20online%20on%20a%20Chromebook%2C%20with%20the%20same%20results.%3C%2FP%3E%3CP%3EThank%20you%20very%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2923779%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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!

0 Replies