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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't Explain N/A in Vlookup 2
Lookup function to cell containing multiple values 3
Prepend cell contents with adjacent cell? 3
VBA set thick borders around non empty cells in range 0
Help: Text to Columns & MDY 2
MACRO RUN random percentage and copy of column values 1
How to check the whole column at the same time? 9
Populate cell with multiple non-blank text values 3

Back
Top