excel_junior
New Member
Hi,
Thanks to all
- 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.
Thanks to all