Excel file merge 2 cells with line break

Hi,

I have column A with "Stephen mathew" and column "B" with "#Stephen #mathew"

Now i want a column that gets as
Stephen mathew
#Stephen #mathew

one below other within a cell

Any help would be highly appretiated.

thanks
mtthompsonsAsked:
Who is Participating?
 
D PatelConnect With a Mentor D Patel, Software EngineerCommented:
You can also use the below formula to get the same as suggested by Norie

=CONCATENATE(A1,CHAR(10)&CHAR(13),B1)

then word wrap the result column.

Regards,
D Patel
0
 
NorieVBA ExpertCommented:
You could do it by using a simple formula =A1&CHAR(10)&B1 and turning on Wrap Text.

If you want code for it post back.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.