asterisks

Hello all, I am looking to format cells that contain asterisks as part of the cell. So this is not a wildcard situation. I've got two types of cell conditions I want to highlight. Cells that contain asterisks will either start with 1 asterisk or 2 asterisks. I need different colors for both...

I'm trying to make an IF formula to detect if there's any asterisks in the worksheet. =IF(WORKSHEET RANGE," * DOES NOT MEET SPECIFICATIONS ","") That way if there is one it will display *DOES NOT MEET SPECIFICATIONS" and if there isn't one it displays nothing.

hello! I have a column of numbers in the form of 70.00.01.0024, 70.00.01.0013, 71.00.00.0013, 71.00.00.0024, etc. What im trying to do is, find the cells and cut the rows that they are at (e.g. B1:B4). I tried doing that searching 70.**.**.**24 but doesn't work. here's what I have so far...

Good morning, I am curious whether it is possible to round a number with asterisks, but keeping those characters in the output? I have a regression tables with many decimals and significance levels ***, ** or * moreover some numbers are in parentheses. Would it be possible/exist a simple way to...

Hi. I created a UserForm that accepts a password. The property PasswordChar is set to *. This works great in Excel 2010. When I try using the form in Excel 2016 it does not work. The password is literally all asterisks. Any idea on what is happening and how I fix this? I really would like the...