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.
This is easy to do using the InStr function and the Left function:
Dim strFilenameDim strPortionstrFilename = "100dpi.txt"strPortion = Left(strFilename, InStr(strFilename, ".") - 1)