carriage returns in excel

  • Thread starter Thread starter darrellps
  • Start date Start date
D

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
 
Hi
try
=A1 & CHAR(10) & B1 & CHAR(10) & C1

afterwards goto 'Format - cells - Alignment' and check 'Wrap Text'
 
Frank Kabel said:
Hi
try
=A1 & CHAR(10) & B1 & CHAR(10) & C1

afterwards goto 'Format - cells - Alignment' and check 'Wrap Text'
Click to expand...


Thankyou for this it works fine thankyou Frank

Darrell
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting rid of carriage return in cell 4
Separating carriage return data into separate cells 2
Select text before carriage return 2
copying/pasting accurately from a Word table (carriage returns) 1
Importing Text with Carriage Returns inside cell values 2
Remove carriage returns in an Excel document? 3
how do i format carriage returns for each cell in excel? 1
Cut and Paste Text with CRLF into Single Cell 1

Back
Top