Excell - reduce cell value by symbols

[arseniy]

Hello all,

I have VB v.6.3. and Excell 2003.

I did many google.com searches but still couldn't find a solution to reduce Excell's cell value by NN symbols from left or right.

The thing is, I have a prefix like www. and I'd like to cut it 4 symbols.

I suppose it's possible with VB, but as far as I couldn't find an example and haven't used VB for scripting vefore, I hope to find some help here.

Cheers!

[Comintern]

I'm not sure I understand exactly what you are trying to do. You can use the LEFT and RIGHT worksheet functions to remove characters if that is what you are looking for:
=RIGHT(A1,LEN(A1)-4) will strip 4 characters from the left.
=LEFT(A1,LEN(A1)-4) will strip 4 characters from the right.

[arseniy]

Thanks, you saved hours of my struggles!

Now I realize that simple things are so hard to find sometimes!..

:-)

Cheers!