Title: Calculated cells
Last modified: September 9, 2019

---

# Calculated cells

 *  Resolved [rvaneerd](https://wordpress.org/support/users/rvaneerd/)
 * (@rvaneerd)
 * [6 years, 9 months ago](https://wordpress.org/support/topic/calculated-cells/)
 * Hi,
 * At the moment I’m using three columns to display:
    - Firstname: `Rob`
    - (Dutch) Prefix (optional): `van`
    - Lastname: `Eerd`
 * It would be nice if it was possible to “concatenate” these three values into 
   a single cell so I can display just the name (in my case `Rob van Eerd`) in a
   single column.
 * If this is possible, I might even be able to deal with my previous issue with
   the link “hidden” behind the name.
 * Regards,
    Rob.
 * ps. Obviously I could include a hard-coded column where I “fix” this but that
   might be tedious to maintain.

Viewing 1 replies (of 1 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [6 years, 9 months ago](https://wordpress.org/support/topic/calculated-cells/#post-11913092)
 * Hi,
 * thanks for your question, and sorry for the trouble.
 * I see what you mean, but unfortunately, TablePress (or rather the code that it
   uses to evaluate formulas in table cells) does not work with text/strings, but
   only with numbers 🙁
 * Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Calculated cells’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [6 years, 9 months ago](https://wordpress.org/support/topic/calculated-cells/#post-11913092)
 * Status: resolved