Thread: adding strings
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson[_3_] Myrna Larson[_3_] is offline
external usenet poster
  
Posts: 45
Default adding strings
Format$(B) will also eliminate the space.

On Tue, 7 Oct 2003 12:28:10 +0100, "Bob Phillips" wrote:

Julian,

Try

Sub add_strings()
A = "4="
B = Cells(1, "B") 'THE CONTENT OF THE CELLS IS 2
C = A + Trim(Str$(B))

End Sub

Reply With QuoteReply With Quote