You can use the VBA.len function to check the length of the string in the cell.