I am trying to use the "List" function in a calculation to concatenate two fields F1 & F2 but want the result to be displayed without carriage returns and in an order that as F1=v1.
A . 100
B . 200
C . 300
When I do a List(F1, F2) I get the following:
What I want is this in a horizontal format with no carriage returns and be able to include the "=" and "," as is formatted below:
How can this be done with the List function in a calculation?