Need Help inserting Character into formula.

ectiger86 · Jul 3, 2015

I need to insert a "," or a "space" into the following formula so I can space out the results from each cell.

Code:

="CDS RENTAL CATEGORY"&CHAR(10)&" ["[B]&F28&F29&F30&[/B]"]"

I would like the result to read F28, F29, F30. Currently they show up as F28F29F30

Thanks in advance

shg · Jul 3, 2015

="cds rental category" & char(10) & " [" & f28 & " " & f29 & " " & f30 & "]"

ectiger86 · Jul 3, 2015

shg said:
="cds rental category" & char(10) & " [" & f28 & " " & f29 & " " & f30 & "]"

Thanks Man . It worked. I had something similar at one point but no dice.