Excel - Split cell with a delimiter and if delimiter not found get complete cell value to another cell

Question

I have an excel file with data where I want a Split cell with a delimiter and if the delimiter is not found then copy that cell value to another cell

e.g.

ABC Ltd.

ABC Ltd. - Ind

PQR Ltd. - USA

LMN Corp.

Output - delimiter "-"

ColumnA ColumnB

ABC Ltd. ABC Ltd.

ABC Ltd. Ind

PQR Ltd. USA

LMN Corp. LMN Corp.

However, I'm using below formula but not getting what I want.

=TRIM(LEFT(B2,FIND("-",B2)-1))

=TRIM(REPLACE(B2,1,FIND("-",B2),""))

Answer 1

Select the row or column that you want to split,
Now select the DATA > TEXT TO COLUMN
There is an option to convert text to column wizard here you need to select Delimited> next
You can use delimiters for your data and select, then select the destination which is where you can split your data
then select finish.
You'll be able to split the data