Quote:
It did get me thinking in another direction through. Maybe if I extract each year into its own cell, trim the first two numbers off each and put these new values back together. Might it be better to modify the formula in my original post to extract the last 2 numbers and string out the capacity to do up to 20 words.
|
Yes, but it would be very cumbersome, even using Text to columns .
And to put the results together you would have something like =A1&" "&A2&" "....
The UDF NoS provided would be easier ( haven't tested it but I suppose he/she did
)