WatfordKev
Board Regular
- Joined
- Mar 30, 2011
- Messages
- 78
I have two columns, one of which may have repeated data from the other one which I would like to remove / delete... have tried to get this working myself but admitting defeat here!
for example:
A1 contains abcd
B1 contains abcd efgh ijkl mnop
I would like to remove abcd (and the trailing space!) from B1 which would then consist of efgh ijkl mnop
If A1 were to be blank then leave B1 as is.
If A1 contained no match in B1 then also leave B1 as is.
Thanks in advance for any help!
for example:
A1 contains abcd
B1 contains abcd efgh ijkl mnop
I would like to remove abcd (and the trailing space!) from B1 which would then consist of efgh ijkl mnop
If A1 were to be blank then leave B1 as is.
If A1 contained no match in B1 then also leave B1 as is.
Thanks in advance for any help!