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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formula with text and number in cell 7
Convert Numbers to Text 2
How to convert a text in a number value 3
count values in a column, but. . . 12
how to convert number to text 2
convert a number to letter 2
convert vertical to horizontal 2
Function/Formula for Text Conversion 3

Top