Import Excel File without Losing Format

Question

I have an Excel file that has tabs within the cells.  When they are imported into Alteryx, the tabs are gone.  Is there a way to have Alteryx not remove them?  It would help in downstream processing.  Also, it looks like during the import things that looked like numbers in Excel were read as numbers and then converted to text.  Example is in cell D2 of the attached where '001999' was converted to '1999'.  Any way to have Alteryx import leaving as string?

Thanks!

Example.xlsx

Example.yxmd

apathetichell · Answer

If the tabs are in cell values - they should be readable. If they are formatting overlays they would be treated like font type and not read in in the standard read.

NeilFisk · Answer

The formatting I can work around with some formulas but I would still like to have the tabs within the cells come in so that I can use them to cleanse the data.

apathetichell · Answer

Alteryx is reading in the value - not the formatting - so 1999 is the value. It displays as 001999 because of formatting.