LinkBack URL
About LinkBacks
Excel newbie here,
Is there a way to separate a number range within a cell to include all the numbers in between?
Example:
2001-2004
Outcome
2001
2002
2003
2004
Excel newbie here,
Is there a way to separate a number range within a cell to include all the numbers in between?
Example:
2001-2004
Outcome
2001
2002
2003
2004
are you still using Excel 2016?
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
We're using Office 365.
Re: Seperate a range number to include all the numbers inbetween?
with Power Query
raw Custom 2001-2004 2007-2009
Please Login or Register to view this content.
Last edited by sandy666; 03-07-2023 at 01:57 PM.
Can someone explain this??
First formula's output is 4 (as expected)
Please Login or Register to view this content.
This is not working as expected. I expect a range...weird
Please Login or Register to view this content.
Here one more option with power query though
Please Login or Register to view this content.
Last edited by JEC.; 03-07-2023 at 02:42 PM.
Wow thank you Sandy and JEC you guys just made my day so much easier! Can't thank you both enough. Have a nice afternoon.
You are welcome
Does someone has an answer to the issue in post 5? Looks like a bug
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks