Try selecting the column then choose Text-To-Columns on the data menu,
and click Finish.

On 11 Apr, 09:24, Tiffany wrote:
Hi

i have a column that contains 8 digit code. However, the front starts with
'12345678. May i know how to remove the apostrophe ('). Kindly advise.

Thank you