Thread: Excel function sumif help
View Single Post
 
Old 09-03-2021, 12:08 AM
ganesang ganesang is offline Windows XP Office 2016
Competent Performer
  
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Default
Hi thanks for the replay!!

I think the left function use to sort out my issue

LEFT(D116,FIND("#",SUBSTITUTE(D116,":","#",2))-1)
Reply With Quote