Notifications
Clear all
General Excel Questions & Answers
5
Posts
2
Users
0
Reactions
77
Views
Topic starter
Hi,
could you help give me a formula to join string as in attached file?
thz
Posted : 06/05/2017 11:07 pm
You can use a formula such as =A1&"-"&B1 where A1 and B1 contains numbers.
or even =CONCATENATE(A1,"-",B1)
Sunny
Posted : 07/05/2017 12:10 am
Topic starter
Thanks but it is a tough.Example: 1,2,3, 6,10. How can I find the sets of sequential numbers within the list? Like in Col B. Please help!
A B
80108 80108-80110
80109
80110
80520 80520-80525
80521
80522
80523
80524
80525
Posted : 07/05/2017 3:14 am
Hi mey
See if this helps.
Sunny
Posted : 08/05/2017 9:20 pm
Topic starter
Thanks,it works
Posted : 09/05/2017 5:27 am
