Trim Characters then find Min and Max

I have a column of cells with values such as AAA-13-0001, AAA-13-0002 etc. I need a macro to trim the AAA-13- and just leave the last 4 numbers 0001. Then I need to find the Min and Max number from this column and paste it into a 2nd worksheet (C1 and C2). I guess I have to change the column from text to numeric first but I am just starting out with VBA and just need a place to start and could probably figure it out if someone could point me in the right direction. Thanks for any help.

Use this function to get the last 4 digits and convert them into a number:

Please Login or Register  to view this content.

Replace A1 with your cell reference.

Hope this helps.

Pete

That was basically what I needed but I didn't explain it all that well I guess. I was hoping for a macro as the column I need to trim will have a different number of entries each time so I need to scroll through all of the column and trim each entry then find the min and max then paste to another sheet. Thanks for the help.

If you leave it as text it won't be able to determine a min and max. If you need the leading zeroes just custom format the field as 0000.

Please Login or Register  to view this content.

edit: litlle late on my post so others may have said what i already mentioned

Works perfect with a little tweaking. Thanks for all the help

VBA?

This can be done with the formula....
vba with no loop.

Please Login or Register  to view this content.