# Simple Text formula question

**URL:** <https://community.weweb.io/t/simple-text-formula-question/17443>\
**Category:** How do I?\
**Created:** [March 25, 2025, 8:45pm UTC](https://community.weweb.io/t/simple-text-formula-question/17443 "2025-03-25T20:45:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![fredo22](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/fredo22/32/2283_2.png) [@fredo22](https://community.weweb.io/u/fredo22)\
**Post date:** [March 25, 2025, 8:45pm UTC](https://community.weweb.io/t/simple-text-formula-question/17443/1 "2025-03-25T20:45:09Z")

</div>

Looked in weweb docs, but couldn’t find an answer. I have a username field that includes both first and last name. What formula would I use to display only the first name? ie ‘John Doe’ should display ‘John’.

---

<div class="post-metadata">

**Author:** ![Micah](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/micah/32/9102_2.png) [@Micah](https://community.weweb.io/u/Micah)\
**Post date:** [March 25, 2025, 8:53pm UTC](https://community.weweb.io/t/simple-text-formula-question/17443/2 "2025-03-25T20:53:18Z")

</div>

```auto
Split(username,' ')[0]

```

You should however have a dedicated column for first and last names since people can have spaces in their name.