I need an Excel expert

Hi,

i require an Excel expert to help me with what would be for me an extra long data crunch session. however i imagine there sill be some way of doing this quickly.

attached is the data set i need working on. you can see in column 'A' titled 'sku' these are our part numbers. in column 'AU' titled '_media_image' is the image names for the each part number.

i am looking to apply a new image to each part number. the image files have been saved as the part number. but the person that named them used and '_' instead of a '-' which can be easily sorted with a find & replace function. please add .jpg to the end also.

the column 'AW' titled' _media_position' is the order sequence of the images. the new image is to be the last image. so it will be a 2 or a 3 depending on the number of items per product.

the column 'AX' titled '_media_disabled' this should always be 0

to give you an idea of what i am looking for i have done the part numbers that begin with letter A. FYI i do not require the last bits of the part numbers (this is sizing) so using the info above for example the next part number:-
B-200-04-02

AU = B_200.jpg
AW = 2
AX = 0

Please note that i have hidden other fields because they do must not be interfered with.

if you have any questions please ask.