IF Statement

[vicedo]

Hi guys, please i know this is very easy but i'm not just thinking straight.

I'm trying to compute an IF statement for this

Edozie, Victor

=LEFT(Staff_Independence[@Name],FIND(",",Staff_Independence[@Name])-1)

Edozie

<tbody>
</tbody>

I don't want the name in the last column, instead, i want it blank

 

[vicedo]

what does the T syntax mean

 

[Scott Huish]

It is the T function and here is the explanation from the help file:

If value is or refers to text, T returns value. If value does not refer to text, T returns ""

So in my formula, it will return "" if it finds the text because it will return a number or if it didn't it would return the cell value because FIND will return an error if it didn't find the text.

 

[vicedo]

Using ur formula returns 0

 

[Scott Huish]

I'm assuming it's doing that with blank cells, try this:

=IFERROR(T(FIND(",",A1)),A1&"")

 

[vicedo]

Great...Thanks a lot