LinkBack URL
About LinkBacks
Hey, I have a list of movies as follows:
movie 1
movie 14
movie 21
movie 11
How do I change the "movie 1" to "movie" without deleting the other 1's from values like 11,12,13,ect.
Thanks all for your help!
Hey, I have a list of movies as follows:
movie 1
movie 14
movie 21
movie 11
How do I change the "movie 1" to "movie" without deleting the other 1's from values like 11,12,13,ect.
Thanks all for your help!
Last edited by trippin; 04-20-2010 at 12:59 AM.
Do a find and replace and select "Match entire contents of cells" under the options button.
Ctrl+H brings up find and replace. The options button is in the bottom right.
trippin,
Detach/open workbook "Delete 1 but not 11 12 13 - trippin - SDG10.xls" and then run the "DeleteOne" macro.
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Why code anything when find and replace does the trick?
Find and replace doesn't work for this. If you try to replace " 1" with "" it will remove the 1 from the numbers "11, 12, 21, ect."Originally Posted by Uziel
THANK YOU! This worked perfectly. Thanks for spending the time to make this macro for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks