I have one column with hundreds of rows of different values that need to have
paste special values in each cell next to them as all formulas will be
removed in another copy of the excel file.

Is there was to achieve this without having to paste special every
individual cell (can't seem to find anything about this type of thing).

Thanks in advance.

Rgds KYMO