Extracting text

  • Thread starter Thread starter Nemo
  • Start date Start date
N

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
 
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
 
Try
=RIGHT(A1,LEN(A1)-FIND("^",SUBSTITUTE(A1,CHAR(32),"^",LEN
(A1)-LEN(SUBSTITUTE(A1,CHAR(32),"")))))
 
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.
 
Back
Top