Getting Rid of Characters

Excel is an awesome tool if you do not have time to learn programming. Excel is also unbelievably frustrating and evil. However, having even some rudimentary skills with Excel can make sure that your life is less stressful.

My friend recently had a problem in that she had a data sheet with lots of values that had “>=” in front. These characters are not recognized in Excel, and makes it impossible for you to do any kind of calculations. Excel has a number of powerful and flexible functions that might help you, but they tend to rely on snipping out set portions of text (eg – the first 7 letters of a cell). One of my other friends suggested the solution of just using replace.

Replace (“ctrl+H”) is a useful  tool in this case as it finds only specified characters and replaces them. *NOTE* you cannot replace with nothing, you have to replace with a zero. Here is an example of Replace at work:

1 2 3

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s