Thread: Removing text
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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