I have a column with multiple cells. The cells contain text. At the end of some of the cells, there is an unneeded break (there may be other breaks in the cell, but I'm only concerned with the last one). I would like a script to be able to delete this.
Can you post sample of your file?
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
I would like to be able to select a cell or column (such as 'article description') and if there is a carriage return (think it chr(10)) at the end, delete it. There may be other carriage returns within the cell, but I only want the last one deleted.
Capture.PNG
To be sure there is no confusion please attach an Excel sample showning the origunal data and the final result you need
- Battle without fear gives no glory - Just try
Try this code
Please Login or Register to view this content.
Yasser - your script did not work. Not only that, but it requires everything to be in B1:B100. I need it to be based on a selection (cell or column).
PCI - attached is a sample of the file. The actual is much larger (columns and rows deleted)
Last edited by mainemojo; 03-14-2018 at 04:22 PM.
Hi MaineMojo - for this to work there must be a selection
*Per Yassir's suggestionPlease Login or Register to view this content.
Last edited by xladept; 03-14-2018 at 05:03 PM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hello my friend
What about using the line in that way
Please Login or Register to view this content.
mainemojo,
This should do
Please Login or Register to view this content.
xladept - yours works the best because it works with a single cell selection or a row/column selection without any modifications (the other suggestions are based on specific columns, but would need to be modified if I wanted to do anything other than column 'B').
With your script, if I select one cell, it's perfect. If I select a column or row, then I get a "runtime error '5':" - "invalid procedure call or arguement" error even though it does what it's supposed to. I'm assuming that this is because there is no defined boundry to the selection?
Last edited by mainemojo; 03-19-2018 at 12:30 PM.
Try this:
Please Login or Register to view this content.
Perfect! Thank you!
You're welcome and thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks