VBA code not working in some cells in the excel file

[zack8576]

I have this code that copies the text from column B to in front of the text in column K (same row)
See screenshot below, code worked on 163, but not on K164-167; it also worked on K175 but not on 176-179. Any reason why it is doing this?
also, What if I just want to add the text and a space without parenthesis, so (SAN-TOHO)LINER, would become SAN-TOHO LINER

Sub AssignStructureIDToLiner()
  With Range("K2:K" & Range("K" & Rows.Count).End(xlUp).Row)
    .Value = Evaluate(Replace("=if(@=""LINER"",""(""&" & .Offset(, -9).Address & "&"")""&@,if(@="""","""",@))", "@", .Address))
  End With
End Sub

 

[xlhelp15]

In which column you're referring the (SAN-TOHO)LINER ? and your need would be (SAN-TOHO)LINER paste in column K without () and with space right ?

 

[zack8576]

In which column you're referring the (SAN-TOHO)LINER ? and your need would be (SAN-TOHO)LINER paste in column K without () and with space right ?

These are always in column K, yes and yes

 

[xlhelp15]

Great. Will give a try. Could you upload few data's with the help of xl2bb here ? Since it is a image, i need to type every time.

 

[zack8576]

Great. Will give a try. Could you upload few data's with the help of xl2bb here ? Since it is a image, i need to type every time.

I've been having issues with xl2bb, can you download from dropbox ?

2022120031-3.csv

Shared with Dropbox

www.dropbox.com