Concatenate to include carriage return

[ewellis]

Hello, Everyone

Name Address City State Number etc.

I would like to concatenate these and include carriage returns so that
the result looks like this:

Name
Address
City
State
Number

I'm currently using the following code:
#

Please Login or Register  to view this content.

#

I don't know how to get the concatenate function to recognize a
carriage return. Any help would be greatly appreciated.

ewellis

[excel_guy49]

Please Login or Register  to view this content.

Stands for Visual Basics Carriage Return Line Feed

[Kenneth Hobson]

Welcome to the forum. When posting vba code, be sure to enclose it in CODE tags. The # icon makes it easy. You might want to edit your post.

You can use one of vbcr or Chr(13), vblf or Chr(10), or vbcrlf of Chr(13)Chr(10) constants if just want the value. If you want a formula, use =CHAR.

e.g.

Please Login or Register  to view this content.