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.