home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.os.ms-windows.apps
- Path: sparky!uunet!zaphod.mps.ohio-state.edu!rpi!ghost.dsi.unimi.it!univ-lyon1.fr!chx400!news.unige.ch!ugsc2a!plaut
- From: plaut@sc2a.unige.ch (Olivier PLAUT)
- Subject: Re: EXCEL!!! Simple yet lethal question...
- Message-ID: <1992Nov19.151620.1@sc2a.unige.ch>
- Lines: 46
- Sender: usenet@news.unige.ch
- Organization: University of Geneva, Switzerland
- References: <19345.2b0aa332@levels.unisa.edu.au>
- Date: Thu, 19 Nov 1992 13:16:20 GMT
-
- In article <19345.2b0aa332@levels.unisa.edu.au>, yawcl@levels.unisa.edu.au writes:
- > Hi... this is for all those excel macro programming enthusiast out there...
- >
- > How do you do an add texts from two cells into one cell....
- > ( An actual formula for a macro would really be helpful... )
- >
- > I know it sounds trivial... But I'm ripping hairs out over here....
- >
- > I know that the same procedure can be done in Lotus with the
- > string + string command.... But Excel doesn't have a string command...
- >
- > And I haven't been able to find an inverse "parse" command....
- >
- > If that hasn't got you yet... Does Excel's macro programming tool actually
- > have a limit on embeded "AND" and "OR" commands....
- > It got really stuffy at me once when I tried to "OR" two "AND" statements
- > together.... ( Although... the formula was getting a bit long... by this
- > point...) Bear in mind they work brilliantly apart....
- >
- > Paul Leong ..
- > E-mail : yawcl@ntx.city.unisa.edu.au
- >
- > ps. Somebody should start a competition for finding the most puzzeling
- > questions for an application.....
- >
- >
-
- You even don't need a macro for that:
-
- "=REPLACE($B$3;(LEN($B$3)+1);1;$C$3)"
-
- If you place this formula in the current cell, you'll have
- the text of cell C3 added to the end of the text of cell B3.
- Olivier.
-
- --
-
- -------------------------------------------------------------------
- Olivier Plaut |
- Institute of Forensic Medicine | Phone: +41 (22) 702.56.12
- Toxicology Unit | Fax: +41 (22) 789.24.17
- University of Geneva |
- Av. de Champel 9 | E-mail: plaut@sc2a.unige.ch
- CH-1211 Geneve 4 | plaut@cgeuge52.bitnet
- Switzerland |
- -------------------------------------------------------------------
-