im2bz2p345
Board Regular
- Joined
- Mar 31, 2008
- Messages
- 226
This might be a very basic question, but how do you delete specific contents from a cell?
I.E. Here are how my contents in column A look:
Security 1 - Blah Blah - Blah Blah
Security 2 - La La - La La
How would I delete the stuff after the first "-"? Essentially, I just want to keep the Security 1 from cell A1.
Would it begin with this function? =IF(ISNUMBER(FIND("-",A1)
Thanks for the help!
~ Busypee
I.E. Here are how my contents in column A look:
Security 1 - Blah Blah - Blah Blah
Security 2 - La La - La La
How would I delete the stuff after the first "-"? Essentially, I just want to keep the Security 1 from cell A1.
Would it begin with this function? =IF(ISNUMBER(FIND("-",A1)
Thanks for the help!
~ Busypee
Last edited: