complete page numbers

[DocAElstein]

Hello moblid,
Welcome to excelfox.

I do not understand your question

I do not think that anyone can help you if you do not explain much more fully what help you need.

You have said that you have this:
55-59, 123-27, 234-78.
and this
55-9, 123-7, 234-8
Then you say it should become this:
55-59, 123-127, 234-278

????
Possibly I see some logic. But I am not sure.

We cannot guess where your data is and where you want your final output to go.
Please remember that you know exactly all your project details.
We have no idea.
You must give us much much more clear detail of your current data situation and what finally you want.- You must tell us where the data is and where it should go.. etc.. etc… etc..


You have not given us anywhere close to the information we need in order to try to help you.


Alan

[moblid]

Sorry, will try to do better.

Column A has the following elided numbers:
A1: 3, 6-8, 24-56, 78, 123-45, 254-65
A2: 55-6, 122-6, 156-68
A3: 45, 255-8, 212-24

I need the following non elided numbers in column B:
B1: 3, 6-8, 24-56, 78, 123-145, 254-265
B2: 55-56, 122-126, 156-168
B3: 45, 255-258, 212-224

Please note that sometimes the original elision is to the last two digits (as in A1) and sometimes to the last digit (as in A2, A3), but in both cases I need output as in B1, B2, B3.

Moshe