Search code examples
stringexcelexcel-formulaworksheet-function

Delete from a character to the left

I have a column of numbers-hyphen-text (e.g.: 4122555 - Guy Hopkins Construction SIP Trunking).

How can I get this down to just the seven digit account number?

Solution

  • Relying on get this down to just the 7 digit account number you might not even need to SEARCH or FIND, just =LEFT(A1,7) would do (or replace A1 with wherever your 4122555 - Guy Hopkins Construction SIP Trunking is). But my +1 has gone to BryPie.