Excel Text Function

[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)

 

[Peo Sjoblom]

=TRIM(SUBSTITUTE(A1,"Centra",""))

will work if you have city names and centra..

 

[Cesar Zapata]

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