unconcatenate Home Board Archive Index Excel Formulas unconcatenate Posted by rupert on January 08, 2002 8:40 AM How do you unconcatenate? Posted by Mark W. on January 08, 2002 8:49 AM Use some combination of MID, RIGHT, LEFT (nt)