=Right, =Left ??

[neilp]

Hi guys

I have a cell A1 that has a mixture of letters numbers and symbols
The only information I want from this cell are the letters at the beginning
Normally I would think about using =Left(A1,___) but the number of letters is variable. The one constant thing is that the letters I need always have 19 charachters after it.

Hope this makes some sort of sense

Cheers in advance

N

 

[Richard Schollar]

Hi Neil

How about:

=LEFT(A1,LEN(A1)-19)

Best regards

Richard

 

[neilp]

Richard,

As Always your spot on

n