[dragster1090]

How can I Combine text and numbers from different cells (these cells are E1 through E590 and F1 through F590, I need to combine E1 with F1, E2 with F2 etc.) into one of the existing cells by using a formula or a function. I am not good with Excel 2003 and do not understand what I have found in excels help.

[JBeaucaire]

In G1 (or any empty cell on row 1) put this formula, then copy downward to G590:

=E1 & F1

[chathacc]

You can also use " " to add a space or comma (i.e. ", ")

So you would just type in =E1&F1 to combine the information

You can also do =E1&" "&F1 if you want to include a space

Or =E1&", "&F1 if you want to add a comma

You can add any text you would like between the two cells using quotes (i.e "")