Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Combine text and numbers from different cells into one cell by using a formula (https://www.askmehelpdesk.com/showthread.php?t=526775)

  • Nov 17, 2010, 12:46 PM
    dragster1090
    Combine text and numbers from different cells into one cell by using a formula
    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.
  • Nov 18, 2010, 01:23 AM
    JBeaucaire

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

    =E1 & F1
  • Dec 18, 2010, 01:46 PM
    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 "")

  • All times are GMT -7. The time now is 12:17 PM.