shift-del
Well-known Member
- Joined
- Aug 28, 2009
- Messages
- 834
- Office Version
- 365
- Platform
- Windows
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:
I would like to suggest some other ways to solve the problem:
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.
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:
Code:
=MID(B1,LEN(A1)+2,9^9)
I would like to suggest some other ways to solve the problem:
Code:
=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.