Formula to Delete Blanks in Entry

[sideshow23bob]

Hello,
First time poster and I figured out my problem with a VLOOKUP that's been giving me trouble is due to there being a space before some the entries so it's not able to pull it (i.e.00045 vs 00045 [note no space before the first zero in the first one which is what I want])

Is there a way for me to format the actual cells with this extra space in the beginning to not have it?

Thanks

 

[delaneyjm]

Maybe:

=VLOOKUP(RIGHT(A1,LEN(A1)-1),$B$1:$C$100,1,FALSE)

Adjust cell references to suit

 

[sideshow23bob]

Maybe:

=VLOOKUP(RIGHT(A1,LEN(A1)-1),$B$1:$C$100,1,FALSE)

Adjust cell references to suit

Oh wow, actually I just figured it out. It's really easy:
I selected the data and did a Find / Replace and
in Find I just entered a space then did a Replace ALL and it's working fine.

Thanks though for the other solution delaneyjm