Home

save concat values

%3CLINGO-SUB%20id%3D%22lingo-sub-466299%22%20slang%3D%22en-US%22%3Esave%20concat%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-466299%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20combined%20column%20a%20and%20column%20b%20with%20concat%20formula%20in%20column%20c.%20I%20now%20want%20to%20just%20have%20the%20resulting%20value%20be%20static%20with%20the%20result%20of%20the%20formula%20so%20that%20I%20can%20delete%20columns%20a%20and%20b.%20Is%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-466299%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-467821%22%20slang%3D%22en-US%22%3ERe%3A%20save%20concat%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-467821%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F322722%22%20target%3D%22_blank%22%3E%40thibsheltyz%3C%2FA%3E%26nbsp%3B%2C%20if%20only%20copy%20column%20C%20and%20paste%20it%20as%20value%20on%20the%20same%20place%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-469178%22%20slang%3D%22en-US%22%3ERe%3A%20save%20concat%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-469178%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3EI%20did%20try%20and%20it%20didn't%20work.%20Then%20I%20tried%20%22paste%20special%22%20%22%20values%22%20and%20that%20did%20it!%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
thibsheltyz
New Contributor

I've combined column a and column b with concat formula in column c. I now want to just have the resulting value be static with the result of the formula so that I can delete columns a and b. Is this possible?

2 Replies

@thibsheltyz , if only copy column C and paste it as value on the same place

@Sergei BaklanI did try and it didn't work. Then I tried "paste special" " values" and that did it! Thanks!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies