Concatenate numbers together leaving a number

[Sayth]

I was creating a unique id for a column and wanted to concatenate the ascii numeric representations for the letters to the end of an existing id in powerquery.

Such as in this example

trainernumber	trainer_track			Name	working out	answer_id
81483	Randwick	Cummings	James	James Cummings	81483 + 17 + 0 +13	8148317013
81483	Menah	Cummings	James	James Cummings
20602948	Rosehill	Cummings	James	James Cummings
20602948	Agnes Banks/Hawkesbury	Cummings	James	James Cummings
20602948	Warwick Farm	Cummings	James	James Cummings
20602948	Agnes Banks	Cummings	James	James Cummings

<tbody style="box-sizing: border-box;">
</tbody>

When I use '&' powerquery returns an error that it cannot use and with numbers. So this solution fails.

[trainernumber] & Character.ToNumber(Text.Start([trainertrack],1)) & Character.ToNumber(Text.Range([trainertrack],1,1)) & Character.ToNumber(Text.Range([trainertrack],2,1))

To get a working solution with slightly different but still unique answer I used '+'.

[trainernumber] + Character.ToNumber(Text.Start([trainertrack],1)) + Character.ToNumber(Text.Range([trainertrack],1,1)) + Character.ToNumber(Text.Range([trainertrack],2,1))

Just wondering though for reference how can I join them rather than having to add them?

 

[Matt Allington]

Have you tried converting the numbers to text first?

 

[Sayth]

Have you tried converting the numbers to text first?

Thanks. Got it.

Number.FromText(Number.ToText([trainernumber]) & Number.ToText(Character.ToNumber(Text.Start([trainertrack],1))) & Number.ToText(Character.ToNumber(Text.Range([trainertrack],1,1))) & Number.ToText(Character.ToNumber(Text.Range([trainertrack],2,1))))