PDA

View Full Version : Combine text and numbers from different cells into one cell by using a formula


dragster1090
Nov 17, 2010, 12:46 PM
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
Nov 18, 2010, 01:23 AM
In G1 (or any empty cell on row 1) put this formula, then copy downward to G590:

=E1 & F1

chathacc
Dec 18, 2010, 01:46 PM
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 "")