excel help

  • ive just used the trim function, i then tried to copy the trimmed column and paste it into a new column on a new page, and got #REF i cant seem to get it to display the text, pls help

  • Are yu wanting the "values" in your new column?


    If so, copy BUT paste special the results "as Values"


    It sounds like you just pasted (which will paste formulas too, and thus you are getting the #ref error due to your formulas no longer being valid on the new sheet (i.e. different column).



    If you need your formulas to work, you need to Cut & Paste


    If this don't work, post up an eg
    Hope this helps :thumbup:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!