"There may be a way to add the formula to all the rest of the cells in the column in one operation. If someone knows how, please share." Highlight all the cells where the formula is needed, including the cell containing the formula; then choose Edit, Fill, Down. Result: the same formula is in all the highlighted cells. If a series of numbers, dates, etc., is required, follow the same steps as above, except choose Series, then the select the appropriate series. The highlighted cells will then contain the serial numbers, dates, or whatever, e.g., if B2 contains '0' and the series is to be in multiples of '10', enter 10 in the appropriate place. Result: 0, 10, 20, 30 and so on down the column. Rows can also be done and there are several different series to choose from. Have a play - it's fun!! Marion > The formula bar above the table (in the toolbar) will always contain the formula, not the result of the formula. Only the table cells will contain > the > result (the concatenated names). I'm afraid I don't know what you mean by > the > "Sample." Allow me to walk through this step-by-step... > > Create the new column. Right-click the header cell of the new column. Choose > Format Cells... On the Number tab, choose either General or Text and click OK. > > Select (left-click) the top cell in the column. Enter the formula to concatenate the two strings (assuming here given name is in column B and the > surname is in column C and the first row is row 2): > > =B2&" "&C2 > > and hit Enter. When you hit Enter, the formula should disappear and the concatenated name should appear in its place. Now when you Select (left-click) > this cell, the formula will appear in the Insert Function field in the toolbar, > but the result of the formula should appear in the cell. > > To enter the same formula in the rest of the cells, right-click on the cell > you've filled and choose Copy. Then left-click on each cell in the column > and > hit Ctrl-V to copy the formula into the cell. The cell designations in the > formula will adjust to the row it's in. There may be a way to add the formula > to all the rest of the cells in the column in one operation. If someone knows > how, please share. > > Diana > >> -----Original Message----- >> From: computers-bounces@rootsweb.com On Behalf Of Anne Picketts Sent: Monday, August 24, 2009 1:40 PM >> To: computers@rootsweb.com >> Subject: Re: [COMPUTERS] Excel >> On Mon, Aug 24, 2009 at 9:04 AM, Diana Gale Matthiesen < >> Diana@danishdemes.org> wrote: >> > You can change the Formating before or after entering the formulae. >> That is where the frustration lies....................I've >> tried General and >> text on that particular column but neither work. In the >> Format Cells Menu, >> the name is shown as it should be in the Sample but still remains as column/row numbers in the formula bar. >> Anne >> -- >> Anne PICKETTS >> Waipu, NZ >> :-~:-~:-~:-~:-~:-~:-~:-~:-~:-~: >> Take pity on Digest subscribers and remember to SNIP when replying. :-~:-~:-~:-~:-~:-~:-~:-~:-~:-~: >> ------------------------------- >> To unsubscribe from the list, please send an email to >> COMPUTERS-request@rootsweb.com with the word 'unsubscribe' >> without the quotes in the subject and the body of the message > > > > > > :-~:-~:-~:-~:-~:-~:-~:-~:-~:-~: > > Take pity on Digest subscribers and remember to SNIP when replying. > > :-~:-~:-~:-~:-~:-~:-~:-~:-~:-~: > > > > > ------------------------------- > To unsubscribe from the list, please send an email to > COMPUTERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message >

Thanks! > Highlight all the cells where the formula is needed, > including the cell > containing the formula; then choose Edit, Fill, Down. > Result: the same > formula is in all the highlighted cells. <snip> > > Marion > >