Thread: adding strings
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Serkan[_2_] Serkan[_2_] is offline
external usenet poster
 
Posts: 8
Default adding strings

Ctrl+H

Find = one space
Replace = none entry

Replace All



-----Original Message-----
sub add_strings()
A = "4="
B = CELLS(ROW,"B") 'THE CONTENT OF THE CELLS IS 2
C= A + STR$(B)

END SUB

The result is 4= 2

I don't want the space between the 4= & the 2
Is there a way of combining the two, but removing the
leading space ??
.