Column Programs are the results of concatenated cells with commas. I need to be able to remove all commas at end of each cell. I cant seem to use find and replace functions.
Thanks
Column Programs are the results of concatenated cells with commas. I need to be able to remove all commas at end of each cell. I cant seem to use find and replace functions.
Thanks
In your file, I highlighted the data in column B,
used CTRL H (find/replace)
Find ,
Replace (nothing - leave blank)
\It worked fine for me?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
If you've got intermediate commas but you only want to remove any end commas, then if you'd also like a VBA approach, maybe:Please Login or Register to view this content.
FWIW:
Please Login or Register to view this content.
This should do
Please Login or Register to view this content.
Not sure what is going on.. but can't post my solution.. keep getting some firewall message..
Found a thread in the Water Cooler about it.. but nothing i do will allow me to post the code i made..
Last edited by apo; 06-15-2015 at 09:43 AM.
Thank you for this. I just posted the same question
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks