Make initials
Write initials (like JS for Jane Smith) from the names in column A into column B.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Write “Initials” in B1
- Initials formula in B2:B1000
Use it in MacroRoni: open the Starter gallery, search for "Make initials", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More text & ids macros
Text & IDsAdd leading zeros to IDsMake every ID in column A six characters long, like 000123, and keep the zeros.Changes data · backup onText & IDsFix ZIP codes that lost their zeroExcel drops the leading zero from ZIP codes like 02134. Put it back in column E.Changes data · backup onText & IDsGet the domain from emailsWrite the part after @ (the company domain) from column C into column D.Changes data · backup on