merging

S

salietata

i have two 3 columns, one for the day, one for month, and one for year
how can i just merge all of those into one date cell. I know you can d
that formula way with a2&" "&b2 and whatever butim wondering if you ca
just merge those into one cell without using any "='s"
thank
 
R

Ron de Bruin

Hi salietata

You must use a =

But after that you can copy the cell and pastespecial as values

Use this to make it a date
=DATE(C1,B1,A1)
 
Top