Getting Text

[mrh15]

Does anyone know how I can get SURNAME from f(SURNAME,100,,,)
without using macros allowing changes to the number (ie 100) and the lengthof the text (ie SURNAME)

Please Help!!!

 

[Zack Barresse]

kind of ambiguous, don't you think?

w/ exactly what you typed...

=mid(a1,3,7)

 

[Aladin Akyurek]

Does anyone know how I can get SURNAME from f(SURNAME,100,,,)
without using macros allowing changes to the number (ie 100) and the lengthof the text (ie SURNAME)

Please Help!!!

Do you mean...

=LEFT(A1,SEARCH(",",A1&",")-1)

 

[mrh15]

almost but that gives me

f(SURNAME

when all I want is

SURNAME

Thanks

 

[Marc]

Try:

=MID(A1,3,FIND(",",A1)-3)

 

[mrh15]

Cheers mate you are genius !!!!!!1

 

[Zack Barresse]

here...

Book3.xls
	A	B	C	D
6	f(SURNAME,100,,,)
7	SURNAME
Sheet4

now any length, provided the first ( and , are constant.

hth

 

[mrh15]

Cool mate that works as well but why is it better than Marcs one ?

 

[Zack Barresse]

it's not, i was only thinking if the "f" length was variable.

other than that it's identical, but a little more lengthly.

 

[Aladin Akyurek]

almost but that gives me

f(SURNAME

when all I want is

SURNAME

Thanks

Didn't notice the f( bit. So...

=REPLACE(LEFT(A1,SEARCH(",",A1&",")-1),1,2,"")