Hello everyone,
I have a long list which contains text with underscores where some are 3-4 at one place within one cell and at some places there are more than 5:
<tbody>
I ___ like to make a ________ for 4, please.
</tbody>
I want to find and replace them all with 5 underscores like this...
Is it possible to have the name in the list show up on the sheet without the underscore? I have a dropdown menu in a cell which dictates what shows up in a drop down menu of another cell. I don't like how it looks with the underscores... is there a fix, or do I need to get over the cosmetics...
Hello group,
I am looking to extract text data that is between specific underscores.
Example: ONE_TWO_THREE_FOUR_5_6_SEVEN_EIGHT_9_TEN_11
I need to extract element SEVEN. How can I specify to read between specific underscores?
Thank you!
Hello,
I am trying to make naming my files easier. I have a spreadsheet where I have.
FILE NUMBER PROJECT NAME
My boss likes to use the naming convention of:
0001_TPR_PROJECT NAME [TPR being the company name]
I am trying to use =CONCATENATE(TEXT(A1,"0000_TPR_"), B1) but because I...
Hi! Here's an easy one for you guys!
I have this table row of which I want a range including only cells without the underscore char.
The underscores appear in no particular order.
Example:
Apple|Orange|Apple_Nutrients|Orange_Nutrients|Banana|Banana_Nutrients|Banana_Count
Desired range...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.