Excel Text Function

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

Hi anyone who can help me...

I have some info in a spreadsheet as follows:
A1 B1 C1
Centra Dublin Centra Belfast Centra London


If I want to get just Centra out into another cell I would
use =LEFT(A1:C1,6) and this works fine. But I want to
actually get out the area - Dublin, Belfast or London and
some other areas that might have more or less than 7
letters. Any ideas???

Thanks in advance

Ann (Dublin, Ireland)
 
ann.

there are a couple of ways one is by chekin for space using the search
function and the other one is below.

=RIGHT(A1,(LEN(A1)-7))

this will extract the anyword after "CENTRA "

Regards,

Cesar Zapata
 
Back
Top