velohead
Board Regular
- Joined
- Aug 22, 2007
- Messages
- 222
- Office Version
- 365
Hi All,
We use vlookups on staff names, but some staff think it funny to put the name "on two rows in the same cell". I believe this is called a carriage return ???
The problem is it looks ok, but is not ok.
Is there any way to detect them with a formula ?
We use vlookups on staff names, but some staff think it funny to put the name "on two rows in the same cell". I believe this is called a carriage return ???
The problem is it looks ok, but is not ok.
Is there any way to detect them with a formula ?