Help

Re: Text is not text (title is unclear, so I'm adding this)

Solved
Jump to Solution
1149 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Kendrick_Kirk
5 - Automation Enthusiast
5 - Automation Enthusiast

Howdy folks. I have a table I’ve pasted some data into. One of the fields is certainly text, but if I reference it with T(), it says it is not. If I select the cell, there are no other characters hidden or otherwise. If I delete the contents with backspace and retype exactly, it is magically text. Any thoughts?

1 Solution

Accepted Solutions
Kendrick_Kirk
5 - Automation Enthusiast
5 - Automation Enthusiast

Errant spaces BEFORE the text. I only checked after. Fixed.

See Solution in Thread

3 Replies 3
Kendrick_Kirk
5 - Automation Enthusiast
5 - Automation Enthusiast

If I concat it, that field becomes text, but yet “If” can’t find it.
Also, sorting alphabetically puts the original pasted values in front of a typed-in value. So a “W” that was pasted in comes before “A” that’s typed in.

Are there different types of ASCII that I should be aware of?

Kendrick_Kirk
5 - Automation Enthusiast
5 - Automation Enthusiast

Errant spaces BEFORE the text. I only checked after. Fixed.

This is a flaw in Airtable that has frustrated untold numbers of people. Airtable won’t show you your leading spaces when they exist. Instead, Airtable hides all leading spaces from you until you double-click into the field itself. It would be great if you could please email support@airtable.com about fixing this, so that they hear from all the people who are having this problem.