Search
Include comments in search
Pages
Categories
Canoo WebTest
Cricket
Excel
Investments
News Portals
Project Management
Software Testing
Technology
VBA Macros
WordPress
Tags
=left(a1
a1
agile data
agile development methodology
agile methodology
agile modeling
agile software development methods
agile unified process (aup)
ajax
allownativexpath
behavior driven development (bdd)
black box testing
bottom-up method
bottom-up testing
chandigarh lions
chris cairns
client-server
createcookie
daily kickoff and review of goals
dynamic testing
essential unified process (essup)
excel
excel macros
extreme programming
feature driven development (fdd)
firefox
generalism
getxpathcount
href
html
hyderabad heroes
integration
integration testing
inzamam-ul-haq
java
jsp
junit
lahore badshahs
last row in an excel sheet
macros
namevaluepair
nunit
optionsstring
pattern)
pavandeep puddupakkam
responsive development
scrummaster
selenium
selenium commands
selenium ide
selenium rc
short release cycles
software testing
sql injection
sql queries
tau devi lal stadium
test driven development (tdd)
testing
top-down method
unit testing
vba
verifyelementpresent
verifyxpathcount
visual studio 2010
waterfall model
web application testing
what is testing
xpath
Archive
2010
July (6)
June (2)
May (18)
April (5)
March (4)
February (10)
January (6)
2009
October (2)
September (17)
July (4)
May (3)
March (2)
January (4)
2008
December (67)
October (12)
September (24)
Blogroll
Hardware
Good...
Googl...
iOS 4...
Twitt...
Racks...
Design
Good...
Googl...
iOS 4...
Twitt...
Racks...
Linux/Unix
Good...
Googl...
iOS 4...
Twitt...
Racks...
Microsoft
Good...
Googl...
iOS 4...
Twitt...
Racks...
Softwares
Good...
Googl...
iOS 4...
Twitt...
Racks...
Authors
wiki (186)
Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.
© Copyright 2010
Sign in
Home
Archive
Contact
Search
Feed
Sign in
UnLtdGroup| Selenium Wiki
7/8/2009
Remove text strings in excel
Remove text strings in excel If you are looking to remove a particular string from a coloum here is the code
[More]
Be the first to rate this post
Currently 0/5 Stars.
1
2
3
4
5
Posted by:
wiki
Posted on: 7/8/2009 at 1:19 PM
Tags:
=left(a1
,
find(
,
=left(a1
,
find("_200907"
,
a1
,
1)-1)&right(a1
,
len(a1)-find(".xml"
,
a1
,
1)+1)
,
remove text strings in excel
Categories:
Excel
Actions:
E-mail
|
Kick it!
|
DZone it!
|
del.icio.us
Post Information:
Permalink
|
Comments (0)
|
Post RSS