Something like this...?

="person"&A1

HTH
Regards,
Howard

"Brookyboy" wrote in message
...
I have a cell with a number in it 1-10
I want to convert that to text like person1 - person10.
I have tried all sorts of formula but not quite got there yet.
Any ideas fellas?
Thanks in advance.