how to add a character, "-" (hyphen) to the contents of multiple cells in a column,........ example; to add a "-" to cells B2,B12,B15,B17,B18,B19,B25,B31
how to add a character, "-" (hyphen) to the contents of multiple cells in a column,........ example; to add a "-" to cells B2,B12,B15,B17,B18,B19,B25,B31
Try this:
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi and welcome to the forum
You already have a bunch of "-" in each cell. Exactly where do you want to put this? You could probably do this with Find/Replace, using some selective "finds". Something like....
Find 101
replace -101
or maybe
Find ETLH
Replace ET-LH
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
Exactly what I was requiring, as a novice at excel I tried a number of things without success.
thank you
I haven't worked with ranges, however I will try it. thank you for your response.(this is my first try at a forum, I apologize if I've strayed from protocol)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks