Philatelist
New Member
- Joined
- Jan 24, 2023
- Messages
- 8
- Office Version
- 2013
- Platform
- Windows
Hi Guys, I have an application with a max cell entry of 250 characters.
If cell BA2 has a string with more than 250 characters, I need it shortening to 200 and the phrase "......details below" (without apostrophies) adding to the end, otherwise, if less than 250, just the string .
So far I have:
=IF(LEN(BA2>250),LEFT(BA2,200)&(AZ10)),BA2 (Where AZ10 = ".....details below")
No matter how many characters the cell contains, I cannot get the formula to stop the additional text appearing if less than 200.
Please help!
TIA
If cell BA2 has a string with more than 250 characters, I need it shortening to 200 and the phrase "......details below" (without apostrophies) adding to the end, otherwise, if less than 250, just the string .
So far I have:
=IF(LEN(BA2>250),LEFT(BA2,200)&(AZ10)),BA2 (Where AZ10 = ".....details below")
No matter how many characters the cell contains, I cannot get the formula to stop the additional text appearing if less than 200.
Please help!
TIA