Welcome to the Forum interm!

This will go faster if you provide a sample file instead of a picture. See yellow banner at the top of the page.

Do all products start with "["? If so here is one idea.



Values as displayed
A
B
1
B-S
B-S
2
[083
B-S
3
Bish
Bish
4
[EZO
Bish
5
Black
Black
6
[N10
Black
7
[R10
Black
Underlying formulas
A
B
1
B-S
=A1
2
[083
=IF(LEFT(A2,1)="[",B1,A2)
3
Bish
=IF(LEFT(A3,1)="[",B2,A3)
4
[EZO
=IF(LEFT(A4,1)="[",B3,A4)
5
Black
=IF(LEFT(A5,1)="[",B4,A5)
6
[N10
=IF(LEFT(A6,1)="[",B5,A6)
7
[R10
=IF(LEFT(A7,1)="[",B6,A7)