Put a prefix on every ID
Add “INV-” in front of each value in column A. Change the prefix to suit.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Add “INV-” before A2:A1000
Use it in MacroRoni: open the Starter gallery, search for "Put a prefix on every ID", 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