ExcelBanter - Convert number to text

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Convert number to text (https://www.excelbanter.com/excel-worksheet-functions/255813-convert-number-text.html)

Brookyboy

Convert number to text

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

Convert number to text

Hi,
try

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

"Brookyboy" wrote:

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.

Teethless mama

Convert number to text

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

"Brookyboy" wrote:

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.

L. Howard Kittle

Convert number to text

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.

All times are GMT +1. The time now is 12:38 PM.