Count characters
Write the length of each value in column A into column B, to spot text that is too long.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Write “Length” in B1
- Length formula in B2:B1000
- Highlight lengths over 50
Use it in MacroRoni: open the Starter gallery, search for "Count characters", 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