Hi,
I would like to take out the second date from the excel cell as shown below in bold:
3/10/2022 Listing removed $1,225$1/sqft
Source: Zillow Rental Network Premium Reporta problem
2/15/2022 Listed for rent $1,225 (+23.1%)$1/sqft
Source: Zillow Rental Network Premium Reporta problem
8/13/2019 Listing removed $995
Source: American Real PM - STL Reporta problem
6/5/2019 Listed for rent $995
Source: American Real PM - STL Reporta problem
So there are many dates in single cell with text, I would like to take out the second one only. So date might change i.e 12/12/2022 etc.
any suggestion to accomplish it with formula/functions?
I would like to take out the second date from the excel cell as shown below in bold:
3/10/2022 Listing removed $1,225$1/sqft
Source: Zillow Rental Network Premium Reporta problem
2/15/2022 Listed for rent $1,225 (+23.1%)$1/sqft
Source: Zillow Rental Network Premium Reporta problem
8/13/2019 Listing removed $995
Source: American Real PM - STL Reporta problem
6/5/2019 Listed for rent $995
Source: American Real PM - STL Reporta problem
So there are many dates in single cell with text, I would like to take out the second one only. So date might change i.e 12/12/2022 etc.
any suggestion to accomplish it with formula/functions?