Forum Discussion

NeilKloster's avatar
NeilKloster
Brass Contributor
Jun 19, 2020
Solved

Trouble combining two cells into one

Hello,    I am trying to combine a date from cell A1 (=Today()) with a time from cell B1 (3:00:00 PM), but everything I try, I get:    "44001 3:00:00 PM" in C1   I've tried custom formatting, I...
excel
Formulas and Functions
  • Bennadeau's avatar
    Bennadeau
    Jun 19, 2020

    Hi NeilKloster,

    Try this ...

    =CONCATENATE(TEXT(TODAY(),"m/dd/yyyy")&" 3:00 PM")

     

    Ben

pal7mentor's avatar
pal7mentor
Copper Contributor
Jun 19, 2020

NeilKloster 

Combine data using the CONCAT function

  1. Select the cell where you want to put the combined data.

  2. Type =CONCAT(.

  3. Select the cell you want to combine first.

    Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.

  4. Close the formula with a parenthesis and press Enter. An example formula might be =CONCAT(A2, " Family").

Resources