blank cell text

  1. K

    How to display data from one sheet if blank or another if filled

    Hi, I need help to display data from one sheet if blank (or other value if that helps) and data from another sheet if the cell has been filled. I hope it make sense : ) Thank you. Kind regards Krillephar
  2. C

    Auto-Sorting Based on New Input

    I have daisy-chained three spreadsheets together: Data Entry / Data Sorting / Data Crunching In Data Entry someone enters date, time, and event information In Data Sorting the event is assigned a number and then sorted, Descending, by date and then time. In Data Crunching, all sorts of fun...
  3. H

    Remove blanks prefixed in a cell

    How to remove ALL 'blanks' prefixed in a cell? Ex: ABCD Ans: ABCD If: XYAZ Ans: XYAZ
  4. S

    if find blank cell in coloum need to take the header name in remarks

    this is formula need to modify =TRIM(IF(LEN(M311),"",M$1&", ")&(IF(LEN(N311),"",N$1&", ")) I need to remove last comma and add last sentence, if only one blanks cell is there add- ( is not available ) if more than 2 blanks cell need to add at last ( are not available )
  5. W

    Compulsory text in a cell

    I'd like to tell users what to input with existing text. If cell contents are deleted or it remains blank and nothing is input, default text should display i.e. Enter Client Name. Been trying to get there with conditional formatting and I can't make text appear when starting with blank
    • wnoland
    • Thread
    • automatic text blank cell text default text default text in a cell
    • Replies: 4
    • Forum: Excel Questions

We've detected that you are using an adblocker.

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.
Go back
Back
Top