deleting space after text

[reza_doang]

hi all,

how to delete all space after text?
i import data from database, but after that so many space after every text in every cells.

many thanks

 

[anandvarma]

hi all,

how to delete all space after text?
i import data from database, but after that so many space after every text in every cells.

many thanks

try TRIM FUNCTION

if the data is a1 with spaces
= trim(a1)

 

[reza_doang]

nice...many thanks

 

[MarkCBB]

Here is a link to a VBA way of doing it from Mr Excel.
http://www.youtube.com/watch?v=tSJANnbwLo0