Thank you mudraker, for spending the time to explain things to m
instead of just giving me the code. Now I have a good understanding o
the functions and I will be able to figure things out on my own when i
comes to that.

Thanks again,

Relyk

--
Relyk
-----------------------------------------------------------------------
Relykk's Profile: http://www.excelforum.com/member.php...fo&userid=1575
View this thread: http://www.excelforum.com/showthread.php?threadid=27267

Relykk

You can also use a right as a substitute to left. this gets th
characters starting from the right.

Also depending on the version of Excel you are using there is also
reverse string command that opperates the same as instr.

My version of Excel does not have the command so I can not tell you th
actual command nam

--
mudrake
-----------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...nfo&userid=247
View this thread: http://www.excelforum.com/showthread.php?threadid=27267