Home > categories > Packaging & Printing > Preforms > How do I preform the opposite of CONTATENATE in EXCEL?
Question:

How do I preform the opposite of CONTATENATE in EXCEL?

For example, my text is quot;000000435 - PECANLAND MALLquot; and I I want name of the store quot;PECANLAND MALLquot; - how do I separate??

Answer:

If your text is in A1, =MID(A1,FIND(-,A1)+2,1000) If the - will always be present, this will work.
Excel includes three functions for parsing strings. LEFT( ) will allow you to select how many character you want to keep starting from the front of the string. RIGHT( ) does the opposite, keeping the characters at the back end of the string. MID( ) allows you to choose a middle section of a string to keep. Using =RIGHT(A1,10) would give you the last ten characters found in cell A1. If you do not know how many characters you need, you can use the LEN( ) function ti figure it out. Since you do not want the first 12 characters, the string you want to parse is going to be (LEN(A1) -12) So you would want =RIGHT (A1, (LEN(A1) -12)) That would give you all but the first 12 characters of whatever is in cell A1

Share to: