Combining different data

[phillipcook]

Hi all

I have two different types of data that I need to combine. with the data that I have, in column A I have sample sites (example cell A1 contains PW1) and in the column B I have sample date (example cell B1 contains 01-03-2018).

What I need to do in cell C1 have an auto calculation that takes the data from A1 and B1 and make it show the following: PW1 01-Mar-18

I've tried everything that I can think of, but I'm having no luck with the auto calculation. any help on this would be greatly appreciated.

Thanks in advance.

 

[AlanY]

try

=A1&TEXT(B1," dd-mmm-yy")

 

[Alice Morland]

Hi Phillip,
There you go:
Assume PW1 is in B3 and the date is in C3. The result is in the next column, and the formula in the last one on the right.

PW1

01/03/2018

PW1 01-Mar-2018

=CONCATENATE(B3," ",TEXT(C3,"DD-MMM-YYYY"))

<tbody>
</tbody>

 

[phillipcook]

Legend!! I was a bit off. I was going =B3&” “&C3 which worked, but I had to do another calculation first to convert the date to text. So for example the real date in this instant may of been in A1 and this formula would be in B1 =text(A1,”DD-
MM-YY).

So so glad there are excel experts out there keen to help!! Thank you!!!

 

[AlanY]

you're welcome

 

[Alice Morland]

You're welcome Just on a side note, your "DD-MM-YY" will bring different results than "DD-MMM-YYYY".