Thread: Adding Two Text Cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ME @ Home ME @ Home is offline
external usenet poster
  
Posts: 10
Default Adding Two Text Cells


"Sam" wrote:

Hi,

Is there an easy way to concatenate two cells??

Suppose the worksheet has six cells like this:

Row 1: John Smith
Row 2: Dick Jones
Row 3: Property Acme

Rows one and two are the way they should be, but row three should read `Acme
Property' in the right hand cell, while the left hand cell should be empty.

Is there a way to automate this process on a large worksheet without
retyping all the data??

Thanks,

Sam

or if you do not want to use a macro the & symbol will join 2 or more cells


Row 1: John Smith
Row 2: Dick Jones
Row 3: Property Acme
row 4 :=b3 & " " & a3
Reply With QuoteReply With Quote