In Microsoft Excel 2003, I use the following formula [in cell A2 in a sheet named (Allocation)] to refer to several cells from a sheet named (02Mis)
='02Mis'!$A$4&"/"&'02Mis'!$A$11&"/"&'02Mis'!$A$10&"/"&'02Mis'!$A$9&"/"&'02Mis'!$A$13
as shown in the following images.
My question is: how to make each entry appears in a separate line as shown in cell C2 in the top image instead of separated by /
as in cell A2.
I mean how to make the separator a new line
instead of /