To merge data from a few cells and separate it by bullets

[nishant_kotian]

Hi all,

I have a few text data typed in from lets say cell A5:A15.

Is there a macros that we can have which when run can automatically merge the data from A5:A15 to lets say C16 with bullets separating it.

So in short all the text from A5:A15 to be copied under 1 single cell but separated by bullets under C16.

Thanks in advance for all your help and efforts.

Really appreciate all of it.

Nishant Kotian

 

[ka_123!]

TRy this


=Concatenate(A1,A2,A3,........,A15)

 

[t.powley]

To add bullet points and carriage returns use this formula:

=(CHAR(149)&A1&CHAR(10)&CHAR(149)&A2&CHAR(10)&CHAR(149)&A3)

Copy and paste this to the formula, changing the cell reference at the end each time:

&CHAR(10)&CHAR(149)&A4

When the formula is complete..

Right click on the cell with the formula, Click on Format Cells - Alignment - tick the Wrap Text tick box.

 

[nishant_kotian]

To add bullet points and carriage returns use this formula:

=(CHAR(149)&A1&CHAR(10)&CHAR(149)&A2&CHAR(10)&CHAR(149)&A3)

Copy and paste this to the formula, changing the cell reference at the end each time:

&CHAR(10)&CHAR(149)&A4

When the formula is complete..

Right click on the cell with the formula, Click on Format Cells - Alignment - tick the Wrap Text tick box.

You are a star buddy!!!

Thanks a ton!!

 

[nishant_kotian]

TRy this


=Concatenate(A1,A2,A3,........,A15)

Thanks you for all your help!!

I knew the concatenate formula however I wanted to get bullets as well, which works well with the one that T.Powley has replied. Thanks again for your help, buddy!