In terms of formulae see LEFT function

=LEFT(A1;18)
copied down

where A1 holds original

If you need to overwrite the original data values then see the Data -> Text to Columns Feature - use Fixed With and set split to 18 (in Step 3 if preferred you may choose not to Import the 2nd column (skip))