Solution to Problem: Delete all text in a column

Delete all text in a column

I have a work sheet that imports what is originally a text document and by using the text to columns facility I have the data transformed into numeric data.
 I have various columns but the relevant ones are a debit column and a credit column.
All of the data is in its correct column.
 However the source data which runs to 20-30 pages has headers and titles and some of that gets into my columns.
 I have no control over the source.
What I'd like to do is delete any text in the columns.
 It's safe to do that as the text to columns macro has formatted those columns as numeric.
 The text is so varied that I can't use replace.
Any ideas?
Thanks

Anwsers to the Problem Delete all text in a column

Download SmartPCFixer to Fix It (Free)

Select the area of the workksheet from which you want text removed and run this macro:
 
 
Sub TextKiller()
For Each r In Selection
    If IsNumeric(r.Value) Then
    Else
        r.Clear
    End If
Next
End Sub

gsnu201005

System Update Readiness Command: To Fix Delete all text in a column

On running the System Update readiness Command, it will Detect & Replace Incorrect Registry data with the Correct one. Which may ultimately Solve Delete all text in a column in Windows.

1. Open CMD as Administrator by Simply Right Clicking on Start button > Command Prompt (Admin).
2. Now Type or Copy paste "DISM.exe /Online /Cleanup-image /Scanhealth" and hit Enter,
3. Now again Type or Copy paste this "DISM.exe /Online /Cleanup-image /Restorehealth" and hit Enter.
4. Close the Command Prompt Window because we are done.

Reboot your Windows & see if error Delete all text in a column is still there.

Note: Your administrator's password might be needed.

Recommended Method to Repair the Problem: Delete all text in a column:

 

 

How to Fix Delete all text in a column with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Open it, and it will perform a scan for your system. The errors will be shown in the list.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.

Related: Start button will not open up to get to my programs Upgrade from O2000 to O2007 on new PC with Win7 Pro qualifying program not found Task Manager says all programs not responding but they are running just fine Vista does not recognize previous Windows 2003 forms and Excell spreadsheets Is there a fix for this The file is not available Trouble installing Quick Time on a new computer This installation package could not be opened To return Yes if cell in not empty excluding formula in cell The backup did not complete Lenovo ThinkVantage Rescue and Recovery Trying to update from IE6 to IE8 After download IE8 does not run at all Seems to have disabled MusicMatch Jukebox and Help Support Center as well The monitor will not turn off on shut down Unable to open sticky notes When exploring the internet for an article or document the box comes up to prompt me to save or open Either way the new window does not open with the appropriate document How do I change this what is going on this is ludicrous had the account for years now i cannot get in hello Updating information from one worksheet into another What Windows installation adds the Catalog Database entry into the registry key HKLM System CurrentControlSet Control FilesNotToBackup the System Protection tab in System Properties cannot find disk drives so it cannot create a restore point,All System Restore Points Constantly Deleted With VSS Services/volsnap Errors,Apps Not Working When Running Laptop On Battery Windows 8.1,Autofill - How Do I Get Internet Explorer To Autofill My Username And Password?,After A Windows Update (XP) My Dial-up Internet Connection Hangs Up,Am I At Risk If My IP Address Has Been Duplicated? If So, What Should I Do About It?
Read More: [Anwsered] Windows 8 goes black/freezes at start screen afte,How to Resolve - I' m getting script error when accessing a ,How to Resolve - print screen freezing the computer?,Low performance issues when moving from Windows 7 Ultimate R,[Solved] How to compare two columns of two worksheets .,2007 Office Word and Excel Suddenly Stop Working,no less or eqaul blue screen crash help please,When Searching in Google I get an IE Script Error showing line 4 & 117, and cannot open the web address eg. Jetstar.,I have been having trouble with windows explorer crashing all the time. Two days ago I was unable to get passed the starting up screen. I went into F8 and set my start up back to default and now my computer will not even come on.,Why do I get Error messages when trying to print a web page?