Search code examples
excelexcel-formulaworksheet-function

How to subset text from an Excel cell

I have an Excel document with a column full of things that look like this:

Hume F;Wilhelm K;

I want to copy this into a blank cell to the right of it, but only what's before the first semicolon. So it would end up looking like this:

Hume F

Solution

  • Option 1

    Copy the column, on the copy Text To Columns with ; as the delimiter and delete the surplus

    Option 2

    Copy and Paste the entire column then select it Find & Replace, Find what: ;*, Replace All

    Option 3 

    =LEFT(A1,FIND(";",A1)-1)