I have cell shown part no. ST-09717 w/ qty 300pcs. I can't vlookup this cell
from other worksheet, however if I re-type the same part no. in the cell, I
would able to lookup this part no. and find 300pcs.

Is there a easy way to copy format instead of typing each part no. again in
the cell? Please help me ASAP.

Thank you,
Christy

My bet is that you have extra (trailing???) spaces in the cell--or if you
copied|pasted from a web site, you could have some of those HTML non-breaking
spaces (char(160) in the cell.

David McRitchie has a macro that cleans up this kind of stuff:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()"

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

BB wrote:

I have cell shown part no. ST-09717 w/ qty 300pcs. I can't vlookup this cell
from other worksheet, however if I re-type the same part no. in the cell, I
would able to lookup this part no. and find 300pcs.

Is there a easy way to copy format instead of typing each part no. again in
the cell? Please help me ASAP.

Thank you,
Christy

--

Dave Peterson