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;">

0down votefavorite ​

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:

<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;">
</tbody>

0down votefavorite ​

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:

<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;">
</tbody>

</body>

down votefavorite ​

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:

<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;">
</tbody>

 

[Marcelo Branco]

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

M.