Eliminating Blanks

[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

 

[Andy B]

Fernando

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

Andy.

 

[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

 

[Gord Dibben]

foolio

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

Gord