function left on another spreadsheet

Hello there.

I'm a big newb at excel, since i've been using it only to store some data, but never have i used any functions.

I would be really happy if you guys could help me type a function which would:

- limit the length of SKU cell (current cell) to 59 characters
- get category (cell E) and manufacturer (cell f) info
- remove characters such as + &. /, ® ()% O ™ * (using regexreplace), and spaces from the product names replaced by dashes using the function SUBSTITUTE.

All of the data is store on Sheet2 and i'm trying to get it into Sheet1

The result should look like this:

SKU cell (A1)

BCAA-OLIMPSPORTNUTRITION (A2)

Any help will be much appreciated!Capture.jpg

PS: sorry for a double post. Admin please delete the previous one