You no longer have to worry about how to cover up initials in excel. Our powerful solution provides simple and fast document management, enabling you to work on excel documents in a few minutes instead of hours or days. Our service covers all the tools you need: merging, inserting fillable fields, signing forms legally, placing signs, and much more. You don't need to set up extra software or bother with high-priced applications requiring a powerful device. With only two clicks in your browser, you can access everything you need.
Start now and handle all various types of files professionally!
Hey! Welcome back itamp;#39;s another dueling Excel podcast. Iamp;#39;m Bill Jelen from MrExcel. Weamp;#39;ll be joined by Mike Girvin from Excel Is Fun. Someone sent this question in via YouTube to Mike. They have names over here, is kind of last name followed by first name. Although, sometimes thereamp;#39;s initial and they want to get the first and last letters kind of like a monogram. This is a tough one. I have no idea how Mike is gonna solve this without VBA. But I know, Iamp;#39;m going straight over to the VBA. So, weamp;#39;ll do [alt F11] and then insert module. Once I have that module, thereamp;#39;s module 1. Paste some code that I wrote. Letamp;#39;s trying to get this away, so we can see it. So, I created a new itamp;#39;s not a sub itamp;#39;s actually a function and I call that function Monogram and Iamp;#39;m gonna pass it the text in the cell and first thing I did was I used the trim function to get rid of leading and trailing spaces and also any interior