Convert rows of excel into Comma Separated Values

Hello Friends, Today We are going to share an interesting post that teaches you how to convert rows of excel into comma separated values.

We faces this issue when we are trying to upload table data on MySql Server. But we’ve a solution to achieve this using following steps.

  1. Copy Excel Column which contains data.
  2. Open MS Word
  3. Paste your copied data as text.
  4. Press Ctrl+H
  5. Type ^p in Find What Box
  6. Type , in Replace with Box
  7. Click Replace All Button

convert rows of excel into comma separated values

Now you have your comma separated data.

If you like our post about how to convert rows of excel into comma separated values, please share it with others