Text String Missing Characters

[Anonymous]

Hi,

I have created a custom column to retrieve cells from another column that has more than 2 characters.

However the function is cutting the text string short. I have read up and the character limit is well beyond the character count I am trying to display.

IF(LEN('Forms Pro Question Responses'[Name])>2 ,'Forms Pro Question Responses'[Name],BLANK())

The text in the original Name column is displaying all characters.

Any suggestions greatly appreciated 😄

[Anonymous]

Hi @Anonymous 

This formula is working fine for me.

Please check if you have your reference column('Forms Pro Question Responses'[Name]) is Text.

[camargos88]

Hi @Anonymous ,

Can you give some examples of it ?

[Anonymous · Accepted solution]

I figured it out as I went to look for an example -_-. There are 2 columns from the data source and one has trimmed text