[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 313
  • 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
0
Thomas Grassi
Asked:
Thomas Grassi
  • 2
1 Solution
 
zorvek (Kevin Jones)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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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