=MIDB(A1,1,5) : Displays 5 character string in cell A1 starting from 1st position. <br />Displays '''ABC D''' as the output. Space character is also included. | =MIDB(A1,1,5) : Displays 5 character string in cell A1 starting from 1st position. <br />Displays '''ABC D''' as the output. Space character is also included. |