I assume you mean just a bunch of spaces after the last word in the cell.
Another option, depending on if this occurs elsewhere in your sheet, is to go
for a Find/Replace. In the find, hit, say, 2 spaces. then in the replace
leave as is, then replace all... Of course, if you have other spots where a
doulbe space is needed, you may want to go with 3 or whatever you can get
away with...

"Kevin" wrote:

Hi

I have a sheet with 20 columns, some text, some numbers or dates. The
columns with text have lots of empty text after the last character. I can use
the TRIM() function to get rid of it but there are almost a million cells so
it time consuming and excel is prone to crash.

Is there a simpler way to get rid of the data. Note the file is originally a
csv and I am ultimately trying to upload it into an access database so
potentially there are some better ways perhaps just to upload directly to
Access?

thanks
--
Kevin