Solved

How to delete characters in a Cell for Excell 2010

Posted on 2014-03-15
3
297 Views
Last Modified: 2014-03-15
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
Comment
Question by:Thomas Grassi
  • 2
3 Comments
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 500 total points
ID: 39931967
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
 
LVL 23

Author Comment

by:Thomas Grassi
ID: 39931982
Keven

Thanks for the fast response

Worked great.

Tom
0
 
LVL 23

Author Closing Comment

by:Thomas Grassi
ID: 39931983
Worked Great Job
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This script will sweep a range of IP addresses (class c only, 255.255.255.0) and report to a log the version of office installed. What it does: 1.)      Creates log file in the directory the script is run from (if it doesn't already exist) 2.)      Sweep…
This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now