In a standard module paste in:

Sub nopreapostophe()
For Each c In Selection
If c.PrefixCharacter = "'" Then c.Value = c.Value
Next
End Sub

Back at the worksheet, Highlight/Select your desired range of Cells to
examine/fix.
And then run: nopreapostophe()
HTH


"Michael Malinsky" wrote in message
...
Assuming all entries have the apostrophe-single space combo at the
beginning
of the product number, try this:

=RIGHT(A1,LEN(A1)-2)

"Kirk P." wrote in message
...
I've got a column of cells filled with Product ID's. They all have a
space
at the beginning, such as

' 9025342
' 1023456

I've tried Trim, LTrim, Clean, etc, etc. Nothing seems to work on these
cells. Any ideas?