Alignment of IF(LEN) within a Cell.

[aedctalk]

Hi! Wondering how i can make the alignment of a IF(LEN) "pretty."

=IF(LEN(O6), O6&" "&Q6&" $"&S6, "")

O6 is a persons name. q6 and s6 contain numbers....

Then i'm pulling 20 of these if len cells into 1 cell

So i can have a list of all names and numbers..

but alignment is horrible.. the numbers are all ove the place

So i was wondering... is there a way to make a HTML type of table within an IF(LEN) in order to align and center the numbers at like 50% and 80% or something.. does excel even recognize html?



Or any other way to align my numbers within the IF(LEN)?

Thanks

 

[mikerickson]

The easiest way to align different pieces of data is to put them in different cells.
Hiding Columns P and R will bring your data into a nice alignment. (White borders ?)