Combining them should give you this:
Formula:
=LEFT(SUBSTITUTE(SUBSTITUTE(E2,"&",""),"-",""),30)&" "&F2
if it's F2 which is the 'other cell' to be added on the other end of the result.
If it's H2 you want to have before the result, then use:
Formula:
=H2&" "&LEFT(SUBSTITUTE(SUBSTITUTE(E2,"&",""),"-",""),30)
With this entered in the top row of a range of data, hold down the Alt key then double-click the drag-handle at the bottom right of the cell - that will auto-fill the formula down to the next blank row.
Bookmarks