Get the references from the cells that are not blank

[simona123]

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

<tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;">
[TD="class: votecell"]

0down votefavorite
​

[/TD]
[TD="class: postcell"] I need help with a function. In A i have a list of names , but they are separated with blank cells. Is there any way to show these names in B but without that? The result should look like this:


[/TD]

</tbody>

<tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;">
[TD="class: votecell"]

0down votefavorite
​

[/TD]
[TD="class: postcell"] I need help with a function. In A i have a list of names , but they are separated with blank cells. Is there any way to show these names in B but without that? The result should look like this:


[/TD]

</tbody>

</body>

<tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;">
[TD="class: votecell"]

down votefavorite
​

[/TD]
[TD="class: postcell"] I need help with a function. In A i have a list of names , but they are separated with blank cells. Is there any way to show these names in B but without that? The result should look like this:

[/TD]

</tbody>

 

[Marcelo Branco]

Take a look at
Delete Blank Rows in Excel, Remove Blank Cells in Excel | Chandoo.org - Learn Microsoft Excel Online

M.