vbanoob2011
New Member
- Joined
- Jun 5, 2011
- Messages
- 8
i have an excel sheet of a bunch of texts messages from my iphone that i sent to myself (yes, you're reading this correctly).
every message has a duplicate (one sent and one received) and they usually come one after the other. however, when i sent messages in rapid succession, they are interleaved (therefore, I cannot just delete every other row to delete the duplicates). furthermore, in many of the pairs, one text will have an extra space ("message " vs. "message") at the end while the other does not, so some of the pairs are not recognized as duplicates when I ran a macro I found on the web for deleting duplicates.
since I already found a macro for deleting duplicates, can someone tell me how to write a macro where IF there is a space (" ") at the end of a text in a cell, THEN to delete that space, but if not to ignore the cell?
every message has a duplicate (one sent and one received) and they usually come one after the other. however, when i sent messages in rapid succession, they are interleaved (therefore, I cannot just delete every other row to delete the duplicates). furthermore, in many of the pairs, one text will have an extra space ("message " vs. "message") at the end while the other does not, so some of the pairs are not recognized as duplicates when I ran a macro I found on the web for deleting duplicates.
since I already found a macro for deleting duplicates, can someone tell me how to write a macro where IF there is a space (" ") at the end of a text in a cell, THEN to delete that space, but if not to ignore the cell?
