Check condition for copy data from column

[tif007]

I will check data in column AL and column AM.

If column AL have text & column AM not have text ----> column AN write text from Column AL

else column AL have text & column AM have text ----> column AM write text from Column AM

column AL not have text & column AM have text ----> column AM write text from Column AM

Now I use formula as below.

Please Login or Register  to view this content.

But some rows column AM have text - , So Column AN data false.

I will requirement as below.

If column AL have text & column AM have text (-) ----> column AN write text from Column AL

Example from file excel as attached.

Please guide me for solve formula.

[AliGW]

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...a-formula.html