TextToColumns

  • Thread starter Thread starter Luis Rentería
  • Start date Start date
L

Luis Rentería

Hi!

How can I avoid confirming if I wish or not to replace destination cells
while I use Text to Columns function?

It really doesn't matter if the contents of those cells is lost.

Thanks in advance.
 
Luis

This would have to be done through VBA code.

Sub Text_To_Col()
Application.DisplayAlerts = False
''Record your Data>Text to Columns steps here
Application.DisplayAlerts = True
End Sub

Gord Dibben Excel MVP
 
Back
Top