What function should i use?

[Ofirabo]

Hello,

I have column contains "text values" few of them have "-" (hyphen) on their right, what function should i use to exclude and show them in a different column?

for example:

apple
apple -
orange
tomato-

I want to see in a different column the following values:
apple -
tomato-

Thanks
Ofira

 

[Misca]

If you want to pick only the lines with the hyphen on the right you might want to try something like:

=IF(RIGHT(TRIM(A1),1)="-",A1,"")

This formula leaves the ones without the hyphen at the end blank. I decided to use the TRIM there as well just in case there were spaces after the hyphen in the cell value.

If you want to move the contents of the original cell to another column (=leaving the original cell empty) then you need to use a macro or do it manually. If it's enough that the original value with the hyphen at the end isn't visible you could try hiding it with conditional formatting.