Sorry if the Title is missleading, i cant think of anything better without writting a whole sentence in there!
Hi, I have had a brief look around the forums and cannot find the answer, but here it is:
I have a number of tabs on my workbook, in which im taking the tab name in a record on a sheet, this is fine. Now the last word in the tab name is a month, but the month is sometimes written as 'Aug' or 'August'!
As what im trying to is to take that month and use it in another tab in the same worksheet, but i want it set as a full name (e.g. August, July, September etc).
Obviously, i cant do an if statment saying (written in pseudocode)
and if the value is 'August', it will go onto the Else, what i want is the IF to pick up Aug* (so either 'Aug', or anything after that like 'August')
Anyone have any ideas how to do this?
Sorry if this seems confusing
Regards,
David
Bookmarks