Cells and and spaces after a string of text

[H]

Hi,

When downloading information from another system in to excel and when doing
a formula for instance VLOOKUP the formula will never work because the
formats from the download in the cells do not correspond to the format within
excel, becuase there is a space after the text, for example (CLL94 ). For
me to overcome this problem is to delete the spacious and bring it back in
line with excel.

As there is huge volume is there a quicker way I can remove the spaces so
the formats are consistant so formuals can work?

Thanks

Hatle

 

[Frank Kabel]

Hi
try:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

 

[hgrove]

H wrote...

When downloading information from another system in to excel and whe doing
a formula for instance VLOOKUP the formula will never work becaus the
formats from the download in the cells do not correspond to the forma within
excel, becuase there is a space after the text, for example (CLL94 ). For me to
overcome this problem is to delete the spacious and bring it back i line with
excel.

...

If there are trailing spaces in a particular column of data, th
easiest way to remove those unwanted trailing spaces is Data > Text t
Columns, select Fixed Width and immediately click on Finish