# Converting text to a number

**URL:** <https://community.fibery.io/t/converting-text-to-a-number/8471>\
**Category:** API & Programming\
**Created:** [March 19, 2025, 12:31pm UTC](https://community.fibery.io/t/converting-text-to-a-number/8471 "2025-03-19T12:31:15Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![tomvb](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/tomvb/32/8764_2.png) [@tomvb](https://community.fibery.io/u/tomvb)\
**Post date:** [March 19, 2025, 12:39pm UTC](https://community.fibery.io/t/converting-text-to-a-number/8471/2 "2025-03-19T12:39:06Z")

</div>

To add more context: I want to sort a list of addresses by [streetname] [house number]. I’m using the Location type field.

I’m extracting the [streetname] [house number] by using this formula: `Left(FullAddress(Adres), Find(FullAddress(Adres), ",") - 1)` as the house number is not properly added to the addressparts (see [Location field street address](https://community.fibery.io/t/location-field-street-address/4477/1))

This leaves me with a list of addresses that I can sort on. However, as they are Text, the sorting creates a list like this:

Vespuccistraat 19  
Vespuccistraat 1  
Vespuccistraat 20

My thinking is that if I can extract the house number as a Number, I can use it to properly sort this list

---

_[View the full topic](https://community.fibery.io/t/converting-text-to-a-number/8471)._