Remove "ADA" from records in the CSV file

Follow

Comments

1 comment

  • Avatar
    John York

    Hi Taro,

    There is a simple formula that can be used in Excel or Google Sheets. Where A1 has your pasted data (e.g., 1,000.211891 ADA), just enter the following in B1: =LEFT(A1,LEN(A1)-4) which will effectively remove four characters from the right side of the string (space-A-D-A = 4 characters)

    Cheers,

    John

    0
    Comment actions Permalink

Please sign in to leave a comment.