ExcelBanter - Copy data

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Copy data (https://www.excelbanter.com/excel-programming/275220-re-copy-data.html)

PEdro

Copy data

"Pedro" wrote in message news:...
Hi

I have in cell A1 the value 31/09/2003
This is formatted has mmmm/yyyy
So the result is "September 2003"

What code should I write in order for getting the variable strMon with the
first 3 caracters of September "Sep"

Thanks
Pedro

All times are GMT +1. The time now is 10:22 AM.