![]() |
#9
|
||||
|
||||
![]()
If you're only interested in the year part, you could use:
=IF(LEN(A3)<5,A3,YEAR(A3)) In a situation where some data have only years and other data have months & years, that would seem to be the most consistent way of analysing them; otherwise you'd need to analyse the data with months & years separately from the data with years only, to avoid skewing the analysis.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Style for Text Changes from Normal to Heading 1 when Copy-Pasted | Basia | Word | 8 | 08-15-2015 02:32 PM |
![]() |
Chancy | Excel | 3 | 02-03-2015 11:33 AM |
![]() |
kb3264 | Excel | 6 | 07-11-2012 07:12 AM |
![]() |
LarryStroup | PowerPoint | 5 | 01-11-2012 12:47 PM |
![]() |
cathleenmcguire | PowerPoint | 6 | 08-31-2011 08:07 AM |