Podcast 1043

[shift-del]

Hello

The podcast is about a table with company name in column A and address including the company name in column B. The goal is to get the address without the company name.

Bill suggested something like this:

=MID(B1,LEN(A1)+2,9^9)

I would like to suggest some other ways to solve the problem:

=TRIM(SUBSTITUTE(B1,A1,""))
=SUBSTITUTE(B1,A1&" ","")
=REPLACE(B1,1,LEN(A1)+1,"")
=RIGHT(B1,LEN(B1)-LEN(A1)-1)

With SUBSTITUTE() you don't have to worry about the length.
And TRIM() gets rid of any annoying space that ist left.



shift-del

PS: This is my first post in this messageboard.

 

[MrExcel]

Welcome to the MrExcel message board.

Thanks for those cool suggestions. They will be featured in episode 1097 of the podcast on September 8 2009.

Drop me an e-mail to bill at mrexcel.com with a postal mailing address and I will send out one of the Excel Master pins.

Bill