Escape ; while delimilating the text data in excel.

  • 1
  • Question
  • Updated 10 years ago
Hi,

I have very specific requirement in excel. I want to import the text data in excel to get tabular data data is in the below format
firstname;middlename;lastname
john;m;right
july;g;christop;her

I want the data to be as below format
firstname middlename lastname
john m right
july g christop;her

Means I want to skip the ; of third column while delimating;

Do u have any solution for this. Can I use any escape sequence or ASCII character in excel so that while deliminating it escape the ; but whiel dispalying it converst to ;.

Need to solution ASAP.
Photo of Aparna

Aparna

  • 1 Post
  • 0 Reply Likes

Posted 10 years ago

  • 1

Be the first to post a reply!