Hi!
I have a spread sheet with tens of thousands of products. In the column for products name there is a piece that says "2003 - 2006". This makes searching for products that fall in the years 2004 and 2005 very difficult. I would like to expand these dates so that hyphens are replaced with the in-between dates.
E.g. "2003 - 2006" becomes 2003 2004 2005 2006.
Is there some automatic way of expanding these dates? Doing it manually would take forever!
Is this possible?
try this
In B1 and pull formula to the right
=IF(LEFT($A1,4)+COLUMNS($A1:A1)-1>RIGHT($A1,4)+0,"",LEFT($A1,4)+COLUMNS($A1:A1)-1)
2003 - 2006
Last edited by AlKey; 07-24-2014 at 12:14 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks