Extracting text

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Nemo" schrieb im Newsbeitrag
...
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

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

-----Original Message-----
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
.

Hi Nemo!

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Nemo" wrote in message
...
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