Eliminating Blanks

F

Fernando Gomez

Happen that I downloaded a huge list of items from a database, somehow the
list is coming with blank spaces after the item and when I try to match the
items with another list it can not find it, could somebody help me to see if
there is a formula or way to eliminatesblank spaces after the las digit of
the item number:
I.E.

R1J150 End of list downloaded
R1J150End of my other list.

Thanks in advance for your help

Fernando Gomez
 
A

Andy B

Fernando

Depending on the layout and content of your data, you could use Find/Replace
to replace the spaces with nothing!

Andy.
 
F

foolio

couldnt you just use the trim function ??? .

or just hit cntrl h and replace a space with nothing ? .... of cours
that assumes that there are no spaces in the stuff you actually want


but i really dont see why you couldnt use the trim functio
 
G

Gord Dibben

foolio

TRIM Function eliminates extra spaces from cell data, it does not delete blank
cells as OP desired.

Gord
 
Top