if any number are repeating

[johncena]

my document column "M" ,this type of numbers are there.

column "M"
125468A-B
125468A-B
458962
256897
412589A-C
412589A-C
412589A-C

01.i need to remove A-B,A-C part.
02.after that any number are repeating that all the number's end part should add (A,B,C,,,,)it's like this.....
[B]
column "M"
125468A
125468B
458962
256897
412589A
412589B
412589C

pls make macro for me.......

[Vitaly K.]

sorry, i made a mistake

[pike]

its ruff

Please Login or Register  to view this content.

[johncena]

thanks a lot friend.i will try....

[johncena]

wow.it's 500% work.thanks a lot.u done a great help for me.thanks again....

[martindwilson]

non macro method assuming there are no more than 26 of any number as you never said what that shoud be.

[johncena]

non macro method assuming there are no more than 26 of any number as you never said what that shoud be.

thanks friend....

[pike]

Hi johncena
You may want to add some more letters to the choose to cover A-G

Please Login or Register  to view this content.

[DonkeyOte]

johncena,

please avoid quoting posts in their entirety - this simply clutters up the thread.

to reply either use New Post button - if you wish to Quote please quote only those parts necessary to sustain a logical flow to the thread.

[Vitaly K.]

non macro method assuming there are no more than 26 of any number as you never said what that shoud be.

one little addition to your great solution: we can take the same result with only 1 column

it also works as it should, as far as I can see

[johncena]

thanks a lot friends.u all done great help for me......

[DonkeyOte]

This is solved but I'm just adding this to demo how to circumvent the 26 constraint in a single cell approach (based on prior post attachment):

Please Login or Register  to view this content.

however the above makes an assumption that the chars to be stripped pre hyphen are a single alpha only.

I would say a VBA based solution is more practical here - but that's JMHO.

[martindwilson]

id just add another helper col or two and do it with functions LOL and its always handy if you keep for occasions like this this text file

[pike]

Hi johncena
For the best spreadsheet performance ,if you can, its always best to use the excel function first and vba second