carriage returns in excel

[darrellps]

Hi
What i am trying to achieve is the three cells
A = FIRST NAME
B = MIDDLE NAME
C = LAST NAME
I wish to convert into single cell by CONCATENATE
then have a carriage return or return as follows
first name(return)
middle name (return)
last name (return)


thankyou in advance
Darrell

 

[Frank Kabel]

Hi
try
=A1 & CHAR(10) & B1 & CHAR(10) & C1

afterwards goto 'Format - cells - Alignment' and check 'Wrap Text'

 

[darrellps]

Hi
try
=A1 & CHAR(10) & B1 & CHAR(10) & C1

afterwards goto 'Format - cells - Alignment' and check 'Wrap Text'

Thankyou for this it works fine thankyou Frank

Darrell