Looking for formula to extract texts from cell. See sample file. Thanks.
Looking for formula to extract texts from cell. See sample file. Thanks.
Hey BJ,
On the Data Tab use Text to Columns and make the delimiter a "-" character.
Done!
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Please try at B2
=TRIM(MID(SUBSTITUTE($A2," -",REPT(" ",99)),COLUMNS($B2:B2)*99-98,99))
Bo_Ry: Excellent solution. Simply the best! Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks