Vlookup & "space" vlookup

[majestyk]

I am looking up first name and surname from a range with 2 vlookup functions,
=vlookup(value,array,column)&vlookup(value, array,column) - what I get is
JohnSmith - what I want is John Smith. Is there a way to insert a space? I
have tried the """" and others.
Thank you

 

[Mike H]

Try

=vlookup(value,array,column)&" "&vlookup(value, array,column)

Mike

 

[majestyk]

Try

=vlookup(value,array,column)&" "&vlookup(value, array,column)

Mike





- Show quoted text -

Mike - thank you. works well. I'll stay with this forum rather than
the other.