Sean15
Well-known Member
- Joined
- Jun 25, 2005
- Messages
- 698
- Office Version
- 2010
- Platform
- Windows
Hi:
I have a concatenate value in D16.
In K11 formula
=LEFT(D16,FIND("–",D16,FIND("–",D16)+1)-1)
intended to remove all text after the second dash from concatenate value in D16 is returning #VALUE.
Can you help please?
I have a concatenate value in D16.
In K11 formula
=LEFT(D16,FIND("–",D16,FIND("–",D16)+1)-1)
intended to remove all text after the second dash from concatenate value in D16 is returning #VALUE.
Can you help please?