![]() |
#7
|
|||
|
|||
![]()
Hi thanks for the replay!!
I think the left function use to sort out my issue LEFT(D116,FIND("#",SUBSTITUTE(D116,":","#",2))-1) |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel function help | ganesang | Excel Programming | 4 | 09-20-2021 01:48 AM |
Data connection problem excel/sharepoint using an SUMIF array | mwestra74 | Excel Programming | 10 | 11-28-2017 06:26 PM |
![]() |
IFnoob | Excel | 1 | 08-13-2016 11:34 PM |
![]() |
Nobody | Excel | 1 | 06-30-2014 12:26 PM |
![]() |
co-lay | Excel | 3 | 02-13-2012 03:46 PM |