Can anyone give this person some help?
http://www.excelforum.com/excel-form...-in-other.html
It may be a simple solution but I can't get my head around it as I've tried different versions of substitute and left and mid while adding -- to it but with no success.
I think it may require VBA. I'll be interested in seeing what someone comes up with.![]()
Bookmarks