How to mask mid of a text in Excel | How to mask mid of a text in Excel using concat

Learn how to mask mid of a text or a string using Text functions.
I have used five functions to mask the number for 3 different category.
1. Right
2. Mid
3.Left
4. Rept
5. Concat.
If you want to know how to pad text and then mask number, please follow this link.
• How to pad text in Exc...
#masknumbers #masktext #left #mid #right #rept #concat
Keep Watching,Keep learning.

[@ajinkyanaik6651]

Thank you madam....for teaching video in detailed......

[@karpagamexcelprime]

Most welcome 😊 Ajinkya Naik

[@BeboRT]

Insightful 👏👏👏👏👍 Thank you Madam!!

[@karpagamexcelprime]

Most welcome Aarti. It is great to see a die hard excel enthusiast follows all the videos . These feedback are indeed motivating. Many thanks 👍

[@BeboRT]

@@karpagamexcelprime it's my pleasure madam, and I am just fan of yours, I like the way you explain each and everything 😊😊

[@SolomonKinyanjui_sk]

Good work.

[@karpagamexcelprime]

Many many thanks

[@aprillewandowski4114]

Are you able to mask the middle variables from a variable length field? I want to keep first variable and the last two and mask everything in the middle. I have used the left and right function but don't know how to put the corresponding * for all of the variables in the middle.

[@harshupadhyay6824]

Good job ma'am.

[@karpagamexcelprime]

Thanks a lot Harsh🙂

[@mowrishkumar131]

Hello mam,
How to save the excel sheet after masked without the original value in the same sheet.

[@SAN-dk6bj]

ThanQ

[@karpagamexcelprime]

You are most welcome.Keep Watching,Keep Learning

[@pinnibabuchitturi8073]

Hi mam, I've list with masked file, so how to unmasked mam. Plz tel me mam

[@310pallavisingh4]

Hello Ma'am
********4526 how toh decode this, normal num plss help

[@karpagamexcelprime]

Hi Pallavi, At present there is no method to decode the masked number.