I have a sample data like this where I had used the Cross Tab function to create the Name field, and as a result, Cross Tab turned the connectors into underscores. I'd like to parse the Name field into two fields: Date and Letters. I tried using the Text to Column function but if i use "_" as delimited indicator it'll turn all the individual components separated by underscore into different fields. How can I parse the field into two fields? Maybe a formula or function that would turn the "_" at the 11th character (after the date) into something else so I can use the Text to Column function? Thank you in advance
