Trim a string???

  • Thread starter Thread starter Niklas Östergren
  • Start date Start date
N

Niklas Östergren

Hi!

I´d like to trim a string (N1546) and remove the first "N". And convert the
string to a long. Any suggestions?

TIA!
// Niklas
 
Niklas Östergren said:
Hi!

I´d like to trim a string (N1546) and remove the first "N". And convert the
string to a long. Any suggestions?
Click to expand...

CLng(Mid([YourString],2))
 
If you are certain there is only one letter at the front, it's simple:

clng(mid(YourString, 2))
 
Back
Top