View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default Excel concatenation

VB Code wrote...
....
. . . download . . .

....
. . . additional space . . .

....

Almost certainly the unwanted space is a nonbreaking HTML space,
decimal character code 160. In formulas, the easiest way to delete
them would be

SUBSTITUTE(string,CHAR(160),"")