macro for change number between ()

[santosh226001]

hello experts

we got may time solution with this forum once again we face a problem and i came here for soultion. hope we also get this time

We have a very large road recrod in this record in colum D we have follwing type data

1
2
3(200)
3(200)
3(600)
4
5
6(100)
6(900)
.
.
.


we want convert this data in follwing type

1
2
3-1
3-2
3-3
4
5
6-1
6-2


actually where matter in between () those cell change () text to start no - 1 or 2 or 3

we attach sample file for ur kind perusal




thanks in advance

[CK76]

Something like below?

I assumed that you wanted to replace existing values in range and that you had header row and data started at Row2.

Please Login or Register  to view this content.

[CK76]

Hmm, come to think of it. Why did I put it in dictionary...?

Amended code.

Please Login or Register  to view this content.

[santosh226001]

hi sir first thanks for ur responce

its work fine but a place its not work as per my need we attach a sheet where we mention what we want output in show colum S

in row 60 and 61 here not result
15-1
15-2
16-3
16-4

but we want
16-1
16-2

[santosh226001]

Attachemtn is here

[santosh226001]

sir don't know what happen today with my end .. one thred post 2 time and now attachment not attached...

sir my attachment is another my thred with same name... (don't know how's today post 2 thread same name..sorry for this we are trying to attach file here but not attached}

[CK76]

Ok, so there are instances where there's no break between (). In that case, try below.
It can probably optimized a bit more, but should do what's been asked.

Please Login or Register  to view this content.

[santosh226001]

Yes!! this works as per my need thank for ur help

We add rep for ur this valuable help..

Thanks a lot