Notifications
Clear all
Topic starter
How can I remove only the codes in the () in this column?
I'd like to remove the abbreviations in the columns that are inside the () and leave the rest.
Thanks,
Posted : 29/12/2017 9:58 pm
Hi Troy
Try this
=LEFT(A2,SEARCH(" (",A2)-1)
Sunny
Posted : 29/12/2017 10:09 pm
Topic starter
that works - nice job!!!
Posted : 29/12/2017 10:20 pm
you always Amazing Sunny
Happy New Year
Posted : 30/12/2017 1:28 am
Suuny's idea always make Excel user comfortable and easy ..
Happy New Year, everyone in the forum keep striving on with enhanced Excel skills...
Posted : 04/01/2018 9:04 pm
