• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula to leave 3 blank cells and pick value from the 1 cell

excel_junior

New Member
Hi,

  • Any one cell from B1, C1, D1, E1, and F1 contains a value and the rest 4 are empty. I want to create a formula to display the value in A1 from the cell which contains the value.
  • Currently, I use replace option to replace texts from a sentence and extract the date. Am I doing it correctly or is there any better formula? For example, H1 contains “Entry in register on 19 July 2021”. I want to remove “Entry in register on” and display the only date in G1.
I have shown an example for your reference in the attached excel file.

Thanks to all
 

Attachments

  • formula.xlsx
    9.8 KB · Views: 11
Back
Top