Clean/Trim during data import

[Forestq]

Hi,

I'm copying data between two excel:

...
For i=2 to rows_x

   TEMP_city = ws.Range("B" + CStr(i)).Value 'this value can contains space
   wsSC.Range("A" & AT_rows).Value = TEMP_city 
...
next i
...

How can I during this process use Trim or Clean function, to delete "space" etc.??

 

[pedrowave]

Hi Forestq, try this line:

TEMP_city = Trim$(Application.WorksheetFunction.Clean(ws.Range("B" & i).Value))

 

[Forestq]

thanks pedrowave!