Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I put each member of string concatenation in its own line?
for example, I want = "a" & "b" & "c" to appear thus:
a b c in the same cell |
#2
|
|||
|
|||
Hi
Try typing a then Alt+Enter then b then Alt+Enter and then c Andy. "DViolette" wrote in message ... for example, I want = "a" & "b" & "c" to appear thus: a b c in the same cell |
#3
|
|||
|
|||
sorry, I wasn't clear in my question. It needs to happen within a formula
without manual typing. Say the formula is = a12 & b34 & c45 I want these three stacked in a cell without having to manually type anything. "Andy" wrote: Hi Try typing a then Alt+Enter then b then Alt+Enter and then c Andy. "DViolette" wrote in message ... for example, I want = "a" & "b" & "c" to appear thus: a b c in the same cell |
#4
|
|||
|
|||
Change format to Wrap Text
Then change your formula to =a12&Char(10)&b34&Char(10)&c45 Rgds, ScottO "DViolette" wrote in message ... | sorry, I wasn't clear in my question. It needs to happen within a formula | without manual typing. | | Say the formula is | = a12 & b34 & c45 | | I want these three stacked in a cell without having to manually type anything. | | | | "Andy" wrote: | | Hi | | Try typing a then Alt+Enter then b then Alt+Enter and then c | | Andy. | | "DViolette" wrote in message | ... | for example, I want = "a" & "b" & "c" to appear thus: | a | b | c | | in the same cell | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to COnvert text string to number | Excel Discussion (Misc queries) | |||
fixed string length,even other record is copied | Excel Discussion (Misc queries) | |||
How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions | |||
Finding Specific Text in a Text String | Excel Worksheet Functions | |||
How to convert string to a date | Excel Worksheet Functions |