Combine IF, LEFT and FIND Function in Excel

[DataDude28]

I have data in a column that looks like this:

123
123_456
12_34


I need to find the underscore if it exist and display the data to the left of the underscore and if the underscore does not exist then display all data.

So for example, in the column to the right of my data I want the following results:

123
123
12

HELP!!!
DataDude28

 

[Jonmo1]

Welcome to the board..

Try

=LEFT(A1,FIND("_",A1&"_")-1)

 

[gsistek]

Try:
=IF(ISERROR(SEARCH("_",A1)),A1,LEFT(A1,SEARCH("_",A1)-1))

 

[DataDude28]

Jonmo1 & gsistek

Both worked GREAT!!!

Thanks to both of you!!!
MUCH APPRECIATED

 

[Jonmo1]

Glad to help, thanks for the feedback.