concatination of cell contents

[Guest]

pls help with a simple query.

I need to concatinate the contents of two cells into a third cell. For
example,
if cell A1 = "john" and cell B1 = "01.01.2006", I need cell C3 to contain
"john 01.01.2006".

What kind of formula should cell C3 contain?

thanks in advance

 

[R.VENKATARAMAN]

A1&" " &B1
space between two apostrophes

 

[NITESH G]

Hi Venkat
try this formula in C1
= concatenate(a1," ",b1)

 

[Guest]

thanks to all

 

[Guest]

Dear All,
both versions of concatenation work BUT, in the case of the example
specified, that is:

"john" in cell A1
"01.01.2006" in cell B1,

the date gets converted into an integer such that the end result in cell C1
reads:

"john 123456", where '123456' represents an integer by which Excel repesents
the date!

any ideas of how to make the date appear in the form dd.mm.yyyy? I've tried
customising cell C1 accordingly but so far I did not manage.

pls help
thanks

 

[dpt]

Hey,

This formula = =CONCATENATE(A1," ",B1) is the best solution.

Incase u cannot see the date, then , righ click on the resultant cel
and select format cells and select text or keep it default as general.

Try it out.

Dear All,
both versions of concatenation work BUT, in the case of the example
specified, that is:

"john" in cell A1
"01.01.2006" in cell B1,

the date gets converted into an integer such that the end result i
cell C1
reads:

"john 123456", where '123456' represents an integer by which Exce
repesents
the date!

any ideas of how to make the date appear in the form dd.mm.yyyy? I'v
tried
customising cell C1 accordingly but so far I did not manage.

pls help
thanks

 

[Guest]

the result does work, but somewhat is dependant on the date format in cell B1.

date formats dd/mm/yyyy and dd.mm.yyyy will still result in an integer
showing in cell C1, even with a text/general formatting in cell C1

the requested result does show however, if a date "dd.mm.yyyy" is directly
inserted in cell B1. I wonder what am I missing here.

Maybe I need insert a validation mask in cell B1 for the user to input a
date in the format required, but I still think it can be sorted out more
professionally!

archeti

 

[Shake]

Does anyone know if it is possible to Un-concatenate a cell.

If "John Smith" is in cell A2 can i put "John" in cell B2 and "Smith
in cell C2

 

[R.VENKATARAMAN]

use data(menu)-text to columns

delimiter is <space>

in the wizard in the thrid step denote destination as B2