Excel Magic Trick 1199


Formula to Extract Everything After Last Space: Two Formula Solutions

DESCRIPTION

See how to use Formula to Extract Everything After Last Space:
(00:08) Problem Setup
(01:05) Formula with TRIM, RIGHT, SUBSTITUTE, REPT, LEN and LEN functions (from pmsocho at YouTube)
(03:22) Formula with REPLACE, SEARCH, SUBSTITUTE, LEN, LEN and SUBSTITUTE functions

WORKBOOKS