Convert number to text

B

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.
 
E

Eduardo

Hi,
try

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