In my current workflow I have used text to columns to separate data that has been converted from a PDF format. However, due to spacing issues, text to columns does not yield the same date needed in a consistent singular column but the dates do land in 3 consecutive columns. Each date is 8 characters long (xx/xx/xx).
I want to consolidate the dates into one column.
See example below, some dates do fall into [txt6] also, but all relevant dates are contained in either of the 3 columns.
Is it possible to write an IF function that replaces fields that do not have 8 characters with a value that could then be sorted? With the eventual goal of consolidating the 3 columns into one column with the desired dates?
