i have a text file with "^" separated.
when i open this text file in Excel and delimited with "^" then some data has to be truncated.
when i see the length of that cell (=len(A1)) it shows me 32758.(before delimited)
so, is there any limit of characters in one cell??
if yes, then how can i open this text file in Excel without truncated data.
Please suggest me