*Tricky* - trying to concatenate which will permit bullets when copied out

[roylionking]

Hi - this seems to be a bit tricky.
I've got a sheet with columns - each column, say 3 of them, is a list of items (actually they're summary points from colleagues).
I concatenate just using & but clean the text and skip the blanks.
I add a CHAR(10) at the end of each point that I concatenate.

BUT - when I copy into MSWord it looks just as I want - each point on seperate lines. But when I click the bullets button only the top line gets a bullet. All the other lines below seem to be part of the same bullet point even though they have seperate lines.
I've tried CHAR(13), going out on a limb I tried CHAR(244)..just can't get it to work.

How can I use excel to pull together a list which, when copied into word, will allow me to turn into bullet points?

 

[roylionking]

Doh! Just realised that I'm pasting across cells from excel so in word it pastes a table. Bullets et all get screwed up.

Hi - this seems to be a bit tricky.
I've got a sheet with columns - each column, say 3 of them, is a list of items (actually they're summary points from colleagues).
I concatenate just using & but clean the text and skip the blanks.
I add a CHAR(10) at the end of each point that I concatenate.

BUT - when I copy into MSWord it looks just as I want - each point on seperate lines. But when I click the bullets button only the top line gets a bullet. All the other lines below seem to be part of the same bullet point even though they have seperate lines.
I've tried CHAR(13), going out on a limb I tried CHAR(244)..just can't get it to work.

How can I use excel to pull together a list which, when copied into word, will allow me to turn into bullet points?