chrisgarcia78
New Member
- Joined
- Jun 15, 2024
- Messages
- 24
- Office Version
- 2021
- Platform
- Windows
Hi, I have an issue trying to use the following LEFT function that automatically delete all characters after numbers and @. This works but when a row is inserted on top of C6 this formula automatically updates, I would like this formula to stay static even if a row is delected or added. I was trying to add the INDIRECT function to this formula but I can't get it to work. PLEASE HELP!
=LEFT(C$6,MIN(FIND({0,1,2,3,4,5,6,7,8,9,"@"},C$6&"0123456789@"))-1)
=LEFT(C$6,MIN(FIND({0,1,2,3,4,5,6,7,8,9,"@"},C$6&"0123456789@"))-1)