Aug 03 2021 10:05 PM
I am a user and not an expert.
I am given a range of numbers.
example:
in the format 001000001- 001007000 (Word)
Then to Excel (.xlsx) - text 001000001 - 000100700
How do I enter this range of numbers in Excel (.xlsx) so that they convert to a column of numbers?
is there an easy way?
Or do I need an additional program and which program?
how do I do this at all?
Aug 03 2021 10:23 PM
@Andrew500 If you are an MS365 subscriber in the Current Channel you could use the SEQUENCE function, like this:
="00"&SEQUENCE(700,,100001,1)
Enter it in the first cell where you want the sequence to start.
If you want it to be automated based on the text string, you'll need PowerQuery or VBA. Personally, I prefer the first as it is easier to learn and maintain.