Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Mar 16, 2000

Copying Part of a String

Question:
I have a little problem which I can't solve. I will give the question with an example.

I'm working with Excel. In a cell the string "100dpi.txt" is written. Is it possible to copy a part of this string "100dpi" to another cell? How should I do this? In this example the "part of the string" contains six characters before the dot. This part of the string can vary from one to eight characters.

Answer:
This is easy to do using the InStr function and the Left function:

Dim strFilename
Dim strPortion
strFilename = "100dpi.txt"
strPortion = Left(strFilename, InStr(strFilename, ".") - 1)
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date