![]() |
|
#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] |
|
|
Similar Threads
|
||||
| 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 |
Prevent access to raw data in a pivot table?
|
Chancy | Excel | 3 | 02-03-2015 11:33 AM |
Conditional Formatting over copied and pasted data
|
kb3264 | Excel | 6 | 07-11-2012 07:12 AM |
Stop underlining pasted data
|
LarryStroup | PowerPoint | 5 | 01-11-2012 12:47 PM |
Numbered list turns to bullets when copy/pasted
|
cathleenmcguire | PowerPoint | 6 | 08-31-2011 08:07 AM |