Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sun-barr!rutgers!caip.rutgers.edu!toccata.rutgers.edu!rlr From: rlr@toccata.rutgers.edu (Rich Rosen) Newsgroups: comp.sys.mac.apps Subject: Re: Excel question Message-ID: Date: 25 Sep 90 22:40:18 GMT References: Reply-To: dcdwest!vaxf!smh@ucsd.edu Organization: RLRCLC Lines: 19 I am posting this article for a friend of mine without net access. Please send any and all responses to him at the "Reply-To:" address. (dcdwest!vaxf!smh@ucsd.edu) Thanx in advance. The question is: how can you concatenate the text string contents of two different cells into a third cell using a macro? My friend has been able to perform the operation manually using the mouse to grab and select blocks of text and piece them together cut-and-paste fashion, but he cannot figure out how this could be included in an Excel macro. When he runs the recorder to try and capture this set of actions, the actions take place, but the recorder seems oblivious to this and does not record any of the select-cut-and-paste actions into the macro. Searching Excel manuals/books for commands or other methods for doing this has been fruitless. Any ideas? -- "While Mona Lisas and mad hatters, sons of bankers, sons of lawyers, turn around and say 'good morning' to the night, for unless they see the sky, but they can't and that is why they know not if it's dark outside or light." Rich Rosen rlr@toccata.rutgers.edu