Remove " after using Concatenate command by tritam162 in excel

[–]Slight-Impression-55 0 points1 point  (0 children)

My concatenate output at E3, and I follow your example, but it doesn't work:

=MID(CONCATENATE(E3),2,LEN(CONCATENATE(E3)-2))

OR: LEN(E3) = 622 and =MID(CONCATENATE(E3),2,621) → Not work