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
LVL 23
Thomas GrassiSystems AdministratorAsked:
Who is Participating?
 
zorvek (Kevin Jones)Connect With a Mentor ConsultantCommented:
Use this formula:

=RIGHT(A1,LEN(A1)-FIND("|",SUBSTITUTE(A1,"\","|",LEN(A1)-LEN(SUBSTITUTE(A1,"\","")))))

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

Kevin
0
 
Thomas GrassiSystems AdministratorAuthor Commented:
Keven

Thanks for the fast response

Worked great.

Tom
0
 
Thomas GrassiSystems AdministratorAuthor Commented:
Worked Great Job
0
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.

All Courses

From novice to tech pro — start learning today.