eliminating first character

[Luis939]

continuing on my work with strings, i know how to select only a string until a certain character

ActiveCell.Value = Left(ActiveCell.Text, InStr(ActiveCell.Text, " &quot - 1)

in this case a blank

but now how would i be able to still do that, but not start from all the way on the left, i want to skip the first character and then start from the 2nd character (or perhaps 3rd etc.) and then go until the blank, thanks!

 

[HobbitK]

Search VBA Help for Mid .. there are several functions and statements listed with good examples.
Here is one ...
Mid Function Example
The first example uses the Mid function to return a specified number of characters from a string.

Dim MyString, FirstWord, LastWord, MidWords
MyString = "Mid Function Demo" ' Create text string.
FirstWord = Mid(MyString, 1, 3) ' Returns "Mid".
LastWord = Mid(MyString, 14, 4) ' Returns "Demo".
MidWords = Mid(MyString, 5) ' Returns "Function Demo".

HTH
Michael

 

[DrSimon]

Check Instr Help. You'll see that Instr() can have four arguments, If the first one is numeric it will do what you want.

Simon Rouse