In the cell beside it you can try entering =right(cell reference,6). This
should return only the 6 characters on the righthand side.

"gh" wrote:

I have a column that has values in it, space'123456. Is there a paste
special I can use to remove the space and ' , then copy the 123456 to
another cell? I can use a custom format to put in the spaces?

TIA