• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

How to delete characters in a Cell for Excell 2010

Excel 2010

Have a spreadsheet that has over 6500 rows.

A       B                                                                    C         D
1   Alpha\The Sky IS Mine
2   Beta Test Now\How Many Is this
3   A Very Long Name\How Long
4   Double Slash\First Slash\Second Slash

In Column "B" I would like to delete the characters in each cell (6500) of them, up to and including the Slash Character.  If not too complicated also to the second slash character.

If too complicated I can run it a second time to delete the second slash.

I would like the results to look like this

A       B                                                                           C         D
1   The Sky IS Mine
2   How Many Is this
3   How Long
4   Second Slash

How can I do this?

Thanks in advance
Thomas Grassi
Thomas Grassi
  • 2
1 Solution
zorvek (Kevin Jones)ConsultantCommented:
Use this formula:


It will find the last chunk of text after the last backslash.

Thomas GrassiSystems AdministratorAuthor Commented:

Thanks for the fast response

Worked great.

Thomas GrassiSystems AdministratorAuthor Commented:
Worked Great Job
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now