Tip: Easily remove leading characters

Save 5 minutes a day by using ASAP Utilities to quickly remove a given number of leading characters from your cells.

"How to quickly remove a specified number of leading characters..."

Just select the cells and then start:
ASAP Utilities » Text » Delete number of leading characters...

Tip: Easily remove leading characters in your cells

Do you recognize any of these situations?

  • How can I strip off the first 6 characters of a cell and use that as the value of the cell?
  • I have a column (27422 rows long). I would like to delete the first 4 characters.
  • I have a long list of part numbers that start with the letter R. I want to remove the R from the part number. The problem is the R can also appear elsewhere in the part number but I need that to remain in place. Therefore I can't use Excel's find and replace to remove the R.

Just select the cells and then use the following tool:
ASAP Utilities » Text » Delete number of leading characters...

This a quicker alternative than using a temporary column and a combination of the Excel's functions =LEFT(), =MID(), =RIGHT() and =LEN().

Bonus tips, also interesting

How much time will it save?

It's guaranteed that you'll save yourself time and effort by using this tool. However, the actual time saved depends on how much you use Excel, the amount of data you are working with and how often you use this particular tool.
You can easily see how much time ASAP Utilities has saved you so far.

Download

In case you don't have ASAP Utilities yet, you can download the free Home&Student edition (for home projects, schoolwork and use by charitable organizations) or the fully functional 90-day Business trial.
Download page

Comments are closed.

Pinterest