Convert number to text

[Brookyboy]

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.

 

[Eduardo]

Hi,
try

="Person"&" "&TRIM(LEFT(F8,FIND("-",F8)-1))&" - "&"Person"&"
"&MID(F8,SEARCH("-",F8)+1,3)

 

[Teethless mama]

="person"&SUBSTITUTE(A1,"-"," - person")

 

[L. Howard Kittle]

Something like this...?

="person"&A1

HTH
Regards,
Howard