vba vlookup return also the cell formatting

[ReeceB]

Greetings,

I have a formula that uses a table array and the values are shown on 3 separate lines in the one cell as show below...

50Gb / root
8Gb /swap swap partition
10Gb /tmp temp partition

When I use vlookup and place the resultant text into a cell it does not 'honour' the formatting, and it is shown as below...

50Gb / root8Gb /swap swap partition10Gb /tmp temp partition

Q: How can I ensure the formatting is the same in the destination cell as it is in the table array ?

Thanks heaps.

ReeceB