Delete breaklines from columns of excel

Page 1 of 1

0 Replies - 1129 Views - Last Post: 22 May 2012 - 10:00 AM Rate Topic: -----

#1 nighttrain  Icon User is offline

  • D.I.C Head

Reputation: 5
  • View blog
  • Posts: 228
  • Joined: 22-September 10

Delete breaklines from columns of excel

Posted 22 May 2012 - 10:00 AM

Hallo,

My question is how to loop throught the specified column and delete all breaklines in all cells of Excel column? In my case all cells in column K have text and after that i got breakline.

Please help.

P.S Is correct way where looping throught the cells untill the cell is empty to use 
if Cells(x,3).Value = Nothing 
...

Is This A Good Question/Topic? 0
  • +
Page 1 of 1