Excel Simple Concate function

  • Thread starter Thread starter rena
  • Start date Start date
R

rena

Hi all experts,

I would like to concate two field with a carriage return.
I.e. field A1 = "ABC"
field B1 = "DEF"

field F1 = "A1" & carriage return & "B1"

i want to result be "A1
B1 "

how could I achieve this?

Thanks a lot.
Rena
 
Hi Rena
format cell F1 with 'word wrap' and enter the formula
=A1 & CHAR(10) & B1

Note: the formating is required!
 
Hi Franke,
Is the formatting a must??
i tried char(13) before.
also using char(10) I afriad i need to set the width of the field...in order
to make it go to the second / third line.

actually my case need to concate 4 field into 1 field with carriage return
seperating each field.

Thanks.
 
A way without using the function CHAR()is to use ALT ENTER
within quotes for a carriage return. You still need the
wrap formatting, but it may be easier with multiple
carraige returns.
 
Back
Top