Concatenate

%3CLINGO-SUB%20id%3D%22lingo-sub-1490033%22%20slang%3D%22en-US%22%3EConcatenate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1490033%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20how%20to%20do%20a%20column%20of%20model%20numbers%20and%20remove%20the%20UBI-%3C%2FP%3E%3CP%3EExample%20of%20the%20model%20%23%3A%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22154%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22154%22%3EUNI-ACB-AC-US%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1490033%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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

Example of the model #:  

UNI-ACB-AC-US
2 Replies

Hi @Rich_Kalin

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

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

"E1" being the original data.

Bennadeau_0-1593110270943.png

 

Ben

 

@Rich_Kalin 

As variant

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