Friday, October 30, 2015

Excel functions for CUCM BAT

I'm just going to put MS Excel functions here that I use when creating CUCM and Unity Connection BAT files. Thanks for stopping by..


Show everything in A1 to the left of a space (or other delimiter)
=LEFT(A1,FIND(" ",A1)-1) 

Show everything in A1 to the right of a space (or other delimiter)
=MID(A1,FIND(" ",A1)+1,255) 
 

No comments:

Post a Comment