Saturday, 19 August 2017

Excel : Replace comma to line break

For some reason, I need to rearrange my excel data in cell from comma to link break as below:
  1. Selected the range of cells I needed to replace.
  2. Go to Home > Find & Select > Replace or Ctrl + H
  3. Find what: ,
  4. Replace with: CTRL + SHIFT + J
  5. Click Replace All
  6. Hooray here i got my result as below.
This helps me on lots !