Concatenate

[Rich_Kalin]

I would like how to do a column of model numbers and remove the UBI-

Example of the model #:  

UNI-ACB-AC-US

[#2]

Hi @Rich_Kalin, 

Assuming you meant removing UNI- you could use this... 

=RIGHT(E1,LEN(E1)-4)

"E1" being the original data.

Ben

[#3]

@Rich_Kalin 

As variant

=REPLACE(A1,1,4,"")