HOW SEPARATE CSV DATA FROM SEMICOLON ( ; ) TO INDIVIDUAL COLUMN

 HOW SEPARATE CSV DATA FROM SEMICOLON ( ; ) TO INDIVIDUAL COLUMN

If you getting data in csv like this format then follow the process to separate from semicolon.

Select complete column like below image:

Now select "Text to Column" like below image:

select delimited checkmar and select next like below image:

Select TAB and SEMICOLON and click next like below image:

Select GENERAL and click finish like below image:

Now You will get separated data as you want like below image:

Check for other solutions and let us know any solution you want, We will post that solution. Thankyou for visit to us.