Attached is a file that shows external raw data and my desired outcome. It appears there is a tab between in the two. I have researched this, tried Alt+0009 and =Left but I cannot get the result I'm looking for. In 20+ years of using Excel I've never seen this. Can anyone help ?
Bookmarks