Numbers question

New Mac user having a few problems using Numbers . Trying to copy emailed data with fields separated by % and can see no way to tell Numbers to ignore the % sign . Using Open Office this is easily done but I cannot see how to do the same with Numbers . Any advice appreciated

Thanks