Alt+Enter in cell with link to another cell
The worksheet function is CHAR, not Chr (this is VBA). So your formula
should be:
='TAS tran'!AI2&CHAR(10)&'TAS tran'!AJ2&CHAR(10)&'TAS tran'!AK2
Hope this helps.
Pete
On Jan 20, 2:01*pm, Don wrote:
Hi friends
I know in a cell as you type you can press Alt+Enter as you are typing to
show in the cell on next line so you can line up text. *I also know that as a
macro it shows as & Chr(10) & but I want to link to other sheet that has a
few Description lines and put each line of descriptions on its one line in a
cell
When I enter the formula
='TAS tran'!AI2&Chr(10)&'TAS tran'!AJ2&Chr(10)&'TAS tran'!AK2
it gives a #NAME? error.
How can I do in a formula to Alt+Enter so the Description lines start to the
left?
thanks
|