Autocopy

%3CLINGO-SUB%20id%3D%22lingo-sub-1982146%22%20slang%3D%22en-US%22%3EAutocopy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1982146%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%20please.%20I%20have%20an%20issue%20with%20a%20command.%3C%2FP%3E%3CP%3EI%60d%20like%20to%20auto%20copy%20a%20cell%2C%20but%20i%60d%20like%20to%20add%20*%20on%20both%20end.%3C%2FP%3E%3CP%3EEg.%20I%60d%20like%20to%20auto%20copy%20A10%20to%20B45.%20123456%20to%20*123456*.%3C%2FP%3E%3CP%3EHow%20can%20I%20manage%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1982146%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1982239%22%20slang%3D%22en-US%22%3ERe%3A%20Autocopy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1982239%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F899695%22%20target%3D%22_blank%22%3E%40MrFriss%3C%2FA%3E%26nbsp%3BPerhaps%20you%20mean%20this%20in%20B45%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3D%22*%22%26amp%3BA10%26amp%3B%22*%22%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

Can someone help me please. I have an issue with a command.

I`d like to auto copy a cell, but i`d like to add * on both end.

Eg. I`d like to auto copy A10 to B45. 123456 to *123456*.

How can I manage it?

2 Replies

@MrFriss Perhaps you mean this in B45

="*"&A10&"*"

 

@Riny_van_Eekelen Thank you so so so so much!!!!!!