Thread
:
Removing text
View Single Post
#
5
Posted to microsoft.public.excel.misc
CLR
external usenet poster
Posts: 1,998
Removing text
=left(a1,11)
Vaya con Dios,
Chuck, CABGx3
"pokdbz" wrote:
I have a variable and I need to remove everything after the last "_" in a
string including the "_".
Example
abc_def_ghi_jklmnop
Result: abc_def_ghi
Reply With Quote
CLR
View Public Profile
Find all posts by CLR