Sure. Let's say your list is in column A. In B1, just enter the formula ="E"&A1, then grab the fill handle on cell B1 and copy that formula all the way down column B
Or...if you want a space between the E and the names, use this formula: ="E"&" "&A1 Linda Publisher ~ ABC ~ All 'Bout Computers Owner ~ Linda's Computer Stop http://personal-computer-tutor.com/main.htm Author/Teacher ~ MS Office EBooks/Classes http://personal-computer-tutor.com/services.htm -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ted Mozer Sent: Sunday, May 12, 2002 10:25 PM To: [EMAIL PROTECTED] Subject: PCWorks: Excel In Excel, is it possible to concatenate text down a column of cells? For example, I have a list of names that I have to put the letter E in front of the name....... ============= PCWorks Mailing List ================= Don't see your post? Check our posting guidelines & make sure you've followed proper posting procedures, http://pcworkers.com/rules.htm Contact list owner <[EMAIL PROTECTED]> Unsubscribing and other changes: http://pcworkers.com =====================================================
