def clean_value(value):
    """Clean spreadsheet values of issues that will affect validation """
    if value == 'n/a':
        return 'N/A'
    elif value == 'Design was registered before field was added':
        return ''
    return value