Expression to align vertically and insert horizontal spaces

[#1]

Hello,

Hopefully this is a simple task.

I have a test box which contains 6 expressions within which contains phrases. The expressions show a summary of KPIs and their corresponding values. See below.

=

'KPI 1' &'  =  '& Expression 1

&','

'KPI 2' &'  =  '& Expression 2

&','

'KPI 3' &'  =  '& Expression 3

&','

'KPI 4' &'  =  '& Expression 4

&','

'KPI 5' &'  =  '& Expression 5

&','

'KPI 6' &'  =  '& Expression 6

With the above set up and by re-sizing the text box, the KPIs and their corresponding values are tightly stacked on top of each other such as follows....

KPI 1 = 10

KPI 2 = 11

KPI 3 = 12 etc

I would like the above expression to be written such that the end result has horizontal spaces between each KPI and appears as seen below..........

KPI Name

KPI 1 = 10

KPI 2 = 11

KPI 3 = 12 etc

Any ideas please?

[marcus_malinow]

Try adding chr(10)'s (carriage returns)

'KPI 1 = ' & Expression 1 & ',' & chr(10) & chr(10) &

'KPI 2 = ' & Expression 2 & ',' & chr(10) & chr(10)

etc..

[sunny_talwar · Accepted solution]

Try if this helps:

='KPI 1' &'   =  '& Expression 1 & Chr(10) & Chr(10) &

  'KPI 2' &'  =  '& Expression 2 & Chr(10) & Chr(10) &

  'KPI 3' &'  =  '& Expression 3 & Chr(10) & Chr(10) &

  'KPI 4' &'  =  '& Expression 4 & Chr(10) & Chr(10) &

  'KPI 5' &'  =  '& Expression 5 & Chr(10) & Chr(10) &

  'KPI 6' &'  =  '& Expression 6 & Chr(10) & Chr(10)

[alexandros17]

Is this useful?

'KPI 1' &' = '& '111'

& chr(10) & chr(10) &

'KPI 2' & ' = '& '222'

& chr(10) & chr(10) &

'KPI 3' &' = '& '333'

& chr(10) & chr(10) &

'KPI 4' &' = '& '444'

& chr(10) & chr(10) &

'KPI 5' &' = '& '555'

& chr(10) & chr(10) &

'KPI 6' &' = '& '666'

[antoniotiman]

=Repeat(' ',20)&'KPI Name'&Chr(10)&Chr(10)

&'KPI 1 = '&Expression&Chr(10)&Chr(10)

&'KPI 2 = '&Expression&Chr(10)&Chr(10)

&'KPI 3 = '&Expression&Chr(10)&Chr(10)

..............

[Kushal_Chawda]

something like this

  'KPI 1' &'   =  '& Expression 1 & Chr(13) &

  'KPI 2' &'  =  '& Expression 2 & Chr(13) &

  'KPI 3' &'  =  '& Expression 3 & Chr(13) &

  'KPI 4' &'  =  '& Expression 4 & Chr(13) &

  'KPI 5' &'  =  '& Expression 5 & Chr(13) &

  'KPI 6' &'  =  '& Expression 6 & Chr(13)

[awhitfield]

PS Chr(10) returns a linefeed character, just in case you ask!

Andy

[#8]

Thanks guys,

That's great. All the suggestions worked. Thank You!

But one last thing. The values are returned with over 5 decimal places (as a percentage). How do I restrict the values to only 2 decimal places for example? The expression I tried is as follows but it did not work...

=sum((Expression)*100,'#.00')