There are so many document editing solutions on the market, but only some are compatible with all file formats. Some tools are, on the contrary, versatile yet burdensome to use. DocHub provides the solution to these hassles with its cloud-based editor. It offers robust capabilities that enable you to complete your document management tasks effectively. If you need to quickly Copy initials in Sxw, DocHub is the best option for you!
Our process is incredibly simple: you import your Sxw file to our editor → it instantly transforms it to an editable format → you apply all required adjustments and professionally update it. You only need a few minutes to get your work ready.
As soon as all modifications are applied, you can turn your paperwork into a multi-usable template. You only need to go to our editor’s left-side Menu and click on Actions → Convert to Template. You’ll locate your paperwork stored in a separate folder in your Dashboard, saving you time the next time you need the same template. Try DocHub today!
hey welcome back its another dueling Excel podcast Im bill Gellin from mr. excel will be joined by Mike urban 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 there is 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 Im going straight over to VBA so well do alt f11 and then insert module once I have that module theres module 1 and when I paste some code that I wrote lets try and get this the way you see it so I created a new its not a sub its actually a function yeah I called that function monogrammed Im 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 double spaces started out with monogrammed being equal to nothing and I know that the last name is in tha