Extracting text

[Nemo]

Hi all,

I have the following data in column a. How can I write a
formula that will extract the last part i.e. the a, ab,
abc, abcd, abcde.

a
1 Text Text a
2 Text Text ab
3 Text Text abc
4 Text Text abcd
5 Text Text abcde


Many thanks

 

[Frank Kabel]

Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=MID(A1,MAX(IF(MID(A1,ROW(INDIRECT("1:1024")),1)="
",ROW(INDIRECT("1:1024"))))+1,1024)

and copy down for all rows

 

[GerryK]

Try
=RIGHT(A1,LEN(A1)-FIND("^",SUBSTITUTE(A1,CHAR(32),"^",LEN
(A1)-LEN(SUBSTITUTE(A1,CHAR(32),"")))))

 

[Norman Harker]

Hi Nemo!

Use:
=MID(A5,FIND("#",SUBSTITUTE(A5," ","#",LEN(A5)-LEN(SUBSTITUTE(A5,"
",""))))+1,255)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.