Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
A B
Angola-Unitel Mobile 244-92 Anguilla-Digicel Mobile 1264-581, 1264-582, 1264-583, 1264-584 Anguilla-Mobile 1264-235, 1264-469, 1264-476, 1264-536 Anguilla-Other 1264 Antigua & Barbuda-Mobile 1268-464, 1268-72, 1268-764, 1268-770 Antigua & Barbuda-Other 1268 Argentina-Buenos Aires 54-11 Argentina-Central 54-230, 54-232, 54-291, 54-299, 54-342, 54-348 I have those sequences of numbers, first of all I want to take off the "-" from those numbers it'll be looks like that: "1264581" not "1264-581", and the big step, I want to put every number from a sequence (for exemple from B2) bottom, it should be like this: A B Angola-Unitel Mobile 24492 Anguilla-Digicel Mobile 1264581 Anguilla-Digicel Mobile 1264582 Anguilla-Digicel Mobile 1264583 Anguilla-Digicel Mobile 1264584 Anguilla-Mobile 1264235 Anguilla-Mobile 1264469 Anguilla-Mobile 1264476 Anguilla-Mobile 1264536 Anguilla-Other 1264 Antigua & Barbuda-Mobile 1268464 Antigua & Barbuda-Mobile 126872 Antigua & Barbuda-Mobile 1268764 Antigua & Barbuda-Mobile 1268770 Antigua & Barbuda-Other 1268 Argentina-Buenos Aires 5411 Argentina-Central 54230 Argentina-Central 54232 Argentina-Central 54291 Argentina-Central 54299 Argentina-Central 54342 Argentina-Central 54348 thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Show Next Number in sequence | Excel Worksheet Functions | |||
How can I match a random number with closest number from sequence? | Excel Worksheet Functions | |||
Display zero at the begnning of a number sequence in Excel | Excel Discussion (Misc queries) | |||
Number sequence | Excel Discussion (Misc queries) | |||
number sequence gap | Excel Worksheet Functions |