How to Delete Returns in Excel
The pesky carraige return and new line characters, while providing a way to present text for human viewing, are not always desirable when working in a spreadsheet program like Microsoft Excel or OpenOffice.org.
In Excel, a bit of code provided by Ivan Moala on mrexcel.com, works wonders. Here is the code:
'Created by Chip Pearson
'Cleans up data by removing tabs and carriage returns in worksheet cells.
Sub CleanUp()
Dim TheCell As Range
For Each TheCell In ActiveSheet.UsedRange
With TheCell
If .HasFormula = False Then
.Value = Application.WorksheetFunction.Clean(.Value)
End If
End With
Next TheCell
End Sub
Here’s how to use it:
- In Excel click Tools > Macro > Visual Basic Editor (or just hit Alt-F11)
- In the top-left pane under the Project heading, double-click the name of the sheet you want to strip all the newlines and carriage returns from.
- In the window that pops up, paste the code above into the empty box under where you see General and Declarations.
- Run the macro by clicking the “play” button above, or hit F5
Warning: make a backup copy of your Excel workbook before performing the above procedure.
Posted under Excel, Microsoft, Uncategorized
This post was written by Content Curator on November 16, 2009
Fedora 9 connect: Network is unreachable error
Ran across this installing Red Hat’s free Linux distribution Fedora Core 9 code named Suplhur. Installed totally vanilla install with the GUI anaconda front end. The box sees the NIC, and can ping within the local subnet of the LAN network, but can’t ping out. BTW, it holds a static IP on the network interface card (NIC). Gets the error:
connect: Network is unreachable error
We need to set a default route. Here’s how:
Looked in /etc/sysconfig/network-scripts for the file route-eth0 but it wasn’t there.
Using vi (you can use whichever text editor you prefer) I created that file route-eth0, and put in this one line:
defult via 192.168.0.1
(note: 192.168.0.1 is the LAN IP address of my router. Your router IP address may differ. So you should put in whatever the IP addres of your router is, instead. Most Netgear routers and Qwest DSL boradband modems use 192.168.0.1 and Linksys uses 192.168.1.1 and Belkin uses 192.168.2.1 just to name some common ones.)
Then a simple task of restarting the network and testing:
# service network restart
# ping yahoo.com
Success!
Also, I found that the ethernet adapters weren’t starting automatically. Using the GUI taskbar/ Start Menu, I went into System Administration, then into Services, and enabled the “network” service. Then change runlevel to 3. Ping works so eth0 is up, and that happened at the runlevel change. Change to runlevel 5, test, and… yeppers, it works.
Posted under Freeware, Linux, Network
This post was written by Content Curator on September 24, 2008
Newegg review hack
To write a review for a product, go to this address and append the product # at the end of URL:
https://secure.newegg.com/NewVersion/FeedBack/RateProduct.asp?Item=
Posted under Uncategorized
This post was written by Content Curator on August 29, 2007