-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
cuts
-
B
conditional formating
how would I write a conditional formatting rule that highlights anything in red for the cells in column H that have more than 30 characters in the cell? basically column H is my journal entry description and our accounting software cuts off any characters that exceed 30. I just think it would...- biglb79
- Thread
- characters column conditional cuts easier
- Replies: 3
- Forum: Excel Questions
-
E
Remove before first blank and after " ("
HI Im trying to have the below two formulas combined so that i can remove the first part of text before space and last of a text in same cell after " (". appreciate any help. text in cell A2 <tbody> 200593 Senior Products Systems (United) </tbody> the formula in B2 this cuts out...- everblazing
- Thread
- cell cuts remove space text
- Replies: 5
- Forum: Excel Questions
-
R
Line chart that excludes entries that are "0"
I am building a template that has the revenue forecast over time and multiple different scenarios will be run through this ONE single template. There are some scenarios where revenue cuts off at 2022 for example and some where it cuts off at 2052. Thus, I have to have the same chart, but since...- rwilliams09
- Thread
- chart cuts line revenue scenarios
- Replies: 10
- Forum: Excel Questions
-
L
Formula short cuts?
Hello, I was just wondering if there were some type of short cuts or easy ways to recall or create any specific formulas? I am new to excel and sometimes have trouble creating the formulas. Thanks in advance to anyone who can help:).- Ldj2879
- Thread
- cuts excel formulas short trouble
- Replies: 1
- Forum: Excel Questions
