Hi,
Wonder how I can substring multiplie values from an cell - can't get it work!
Dateformat is like: 01.12.2012.
My script is like: date = Right("cels.......",4)
With this I only get 2012 wich is logic - but how can I solve this so I get this output and format: 2012-12-01.
better to use mid...