| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to insert line-feed in Excel concatenation (VB)
I want to concatenate values from multiple cells into one cell. I want a
line-feed separating the values in the combined cell. I tried using the ASCII character code (10 for linefeed, 13 for carriage return), but its not working the way I did it. Any help is greatly appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need to insert line-feed in Excel concatenation (VB)
="a"&CHAR(10)&"b"
FormatcellsAlignment, check Wrap text -- Kind regards, Niek Otten "Susan W" <Susan wrote in message ... I want to concatenate values from multiple cells into one cell. I want a line-feed separating the values in the combined cell. I tried using the ASCII character code (10 for linefeed, 13 for carriage return), but its not working the way I did it. Any help is greatly appreciated. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need to insert line-feed in Excel concatenation (VB)
Susan,
Try something like =A1&CHAR(10)&A2 or, in VBA Range("B1").Value = Range("A1").Value & Chr(10) & Range("A2").Value Ensure that the cell has Wrap Text enabled (Format menu, Cells, Alignment tab). -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Susan W" <Susan wrote in message ... I want to concatenate values from multiple cells into one cell. I want a line-feed separating the values in the combined cell. I tried using the ASCII character code (10 for linefeed, 13 for carriage return), but its not working the way I did it. Any help is greatly appreciated. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need to insert line-feed in Excel concatenation (VB)
Yes - the Chr(10) did it. Thanks very much!
Susan "Chip Pearson" wrote: Susan, Try something like =A1&CHAR(10)&A2 or, in VBA Range("B1").Value = Range("A1").Value & Chr(10) & Range("A2").Value Ensure that the cell has Wrap Text enabled (Format menu, Cells, Alignment tab). -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Susan W" <Susan wrote in message ... I want to concatenate values from multiple cells into one cell. I want a line-feed separating the values in the combined cell. I tried using the ASCII character code (10 for linefeed, 13 for carriage return), but its not working the way I did it. Any help is greatly appreciated. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need to insert line-feed in Excel concatenation (VB)
I find that using vbLF is a bit more readible and is certainly faster to type
than CHR(10). Am I missing something here? "Susan W" wrote: Yes - the Chr(10) did it. Thanks very much! Susan "Chip Pearson" wrote: Susan, Try something like =A1&CHAR(10)&A2 or, in VBA Range("B1").Value = Range("A1").Value & Chr(10) & Range("A2").Value Ensure that the cell has Wrap Text enabled (Format menu, Cells, Alignment tab). -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Susan W" <Susan wrote in message ... I want to concatenate values from multiple cells into one cell. I want a line-feed separating the values in the combined cell. I tried using the ASCII character code (10 for linefeed, 13 for carriage return), but its not working the way I did it. Any help is greatly appreciated. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need to insert line-feed in Excel concatenation (VB)
vbLF, vbCR etc are certianly more clear to read, but have exactly the same
effect as Chr(10), Chr(13). The only one that may make a difference is vbNewLine, which will give the correct value on a PC or Mac. NickHK "scabHead" wrote in message ... I find that using vbLF is a bit more readible and is certainly faster to type than CHR(10). Am I missing something here? "Susan W" wrote: Yes - the Chr(10) did it. Thanks very much! Susan "Chip Pearson" wrote: Susan, Try something like =A1&CHAR(10)&A2 or, in VBA Range("B1").Value = Range("A1").Value & Chr(10) & Range("A2").Value Ensure that the cell has Wrap Text enabled (Format menu, Cells, Alignment tab). -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Susan W" <Susan wrote in message ... I want to concatenate values from multiple cells into one cell. I want a line-feed separating the values in the combined cell. I tried using the ASCII character code (10 for linefeed, 13 for carriage return), but its not working the way I did it. Any help is greatly appreciated. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need to insert line-feed in Excel concatenation (VB)
Hi Mr.Pearson,
a1&char(10)&a2 works well, but how to make the containing cell collapse automatically when it contains multiple lines Clara -- thank you so much for your help "Chip Pearson" wrote: Susan, Try something like =A1&CHAR(10)&A2 or, in VBA Range("B1").Value = Range("A1").Value & Chr(10) & Range("A2").Value Ensure that the cell has Wrap Text enabled (Format menu, Cells, Alignment tab). -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Susan W" <Susan wrote in message ... I want to concatenate values from multiple cells into one cell. I want a line-feed separating the values in the combined cell. I tried using the ASCII character code (10 for linefeed, 13 for carriage return), but its not working the way I did it. Any help is greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
| How do I insert a line feed in a formula? | Excel Worksheet Functions | |||
| How can I insert a line feed in the text in an EXCEL cell? | Excel Discussion (Misc queries) | |||
| Find/Replace carriage return & line feed characters in Excel. | Excel Worksheet Functions | |||
| how does excel store new line and line feed characters? | Excel Programming | |||
Hybrid Mode
