# Formula to return the alphabet letter based on the number

**URL:** <https://community.fibery.io/t/formula-to-return-the-alphabet-letter-based-on-the-number/9471>\
**Category:** Ideas & Features\
**Tags:** formulas\
**Created:** [August 26, 2025, 12:58pm UTC](https://community.fibery.io/t/formula-to-return-the-alphabet-letter-based-on-the-number/9471 "2025-08-26T12:58:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\
**Post date:** [August 26, 2025, 12:58pm UTC](https://community.fibery.io/t/formula-to-return-the-alphabet-letter-based-on-the-number/9471/1 "2025-08-26T12:58:21Z")

</div>

Input: 1, Output: a.  
Input: 20, Output: t  
Input: 27: Output aa

etc.

Useful when using version coding.

its nicer to see 1a and 1b rather then 1-1 and 1-2.

Can be done manually, but results in big formula.

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [August 26, 2025, 8:26pm UTC](https://community.fibery.io/t/formula-to-return-the-alphabet-letter-based-on-the-number/9471/2 "2025-08-26T20:26:36Z")

</div>

Really need to use a script for that 😟