Convert number to text

  • Thread starter Thread starter Brookyboy
  • Start date Start date
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.
 
Hi,
try

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