Cell problem

[koda86]

Hey!

After the Combo Box problem, a more simple problem but still hard for me!! I hae in one cell a Vlookup formula (=IF(B23<>"",VLOOKUP(B23,PriceList!$B$2:L9,2),"").

how you can put in one cell information coming from 2 cells??? For example, in cell A1 you have 223 and in cell A2 you have euros, I would like to put in cell A3 "223 euros". Is it possible??


Thanks for your help!

[oldchippy]

Try this,

=A1&" "A2

[koda86]

Thank you!! It works but without the ""!!

Thanks again! Hard for a noob, easy for a moderator!!

[oldchippy]

Sorry it should be

=A1&" "&A2 to put the space in between