Reply to thread

Message

<blockquote data-quote="shades" data-source="post: 1215560" data-attributes="member: 4773">Howdy. It has been 3+ years since I worked extensively in Excel. But there are functions that allow you to determine order by counting either from the left or the right. While it could be done in one move, it would result in a difficult formula to set up. I can give you how to get rid of the unwanted characters. ALWAYS work on a backup copy in case things turn bad. Assume your data is in Column C, beginning in row 2:Select the column in which the data appears, then do a find and replace of the underscore (i.e. find it, then replace it with nothing).Or you can use a formula in D2=SUBSTITUTE(C2,&quot;_&quot;,&quot;&quot;)Copy this formula down the entire list by moving cursor to lower right corner of cell, and when it turns into a cross hairs, then double click and it will fill the entire length of the column.Copy column D and paste back onto itself using &quot;paste special values.&quot;Then use the formula again on column D, and put this in E2=SUBSTITUTE(D2,&quot;-&quot;,&quot;&quot;)As for the rest of how to do it, it would be best to visit the best Excel help site to for answers is <a href="http://www.mrexcel.com/forum/" target="_blank">Mr Excel</a>. I used to participate regularly when using Excel everyday. But I don't even have Excel anymore.</blockquote>

[QUOTE="shades, post: 1215560, member: 4773"] Howdy. It has been 3+ years since I worked extensively in Excel. But there are functions that allow you to determine order by counting either from the left or the right. While it could be done in one move, it would result in a difficult formula to set up. I can give you how to get rid of the unwanted characters. ALWAYS work on a backup copy in case things turn bad. Assume your data is in Column C, beginning in row 2: Select the column in which the data appears, then do a find and replace of the underscore (i.e. find it, then replace it with nothing). Or you can use a formula in D2 =SUBSTITUTE(C2,"_","") Copy this formula down the entire list by moving cursor to lower right corner of cell, and when it turns into a cross hairs, then double click and it will fill the entire length of the column. Copy column D and paste back onto itself using "paste special values." Then use the formula again on column D, and put this in E2 =SUBSTITUTE(D2,"-","") As for the rest of how to do it, it would be best to visit the best Excel help site to for answers is [url=http://www.mrexcel.com/forum/]Mr Excel[/url]. I used to participate regularly when using Excel everyday. But I don't even have Excel anymore. [/QUOTE]

Verification

Name this item. 🍎