Show a cell value from a range of cells in another cell

[asokaw]

Hi

I have say 5 cells in column A ( A1-A5) in which I will enter a name in only one of the 5 cells in A column
This entry can vary between the 5 cells but will only be in one of the cells

I need to show that value in cell B5.

Can I do it without VB

Thanks

 

[hrayani]

Hello,

Try in B5

=CONCATENATE(A1,A2,A3,A4,A5)