When
you get a hold of your spreadsheet it's possible that it may include
some text that will need to be altered before it's included in your
hometowners. For example, many schools use standardized abbreviations
for things like the person's class level, gender, major and degree. You
shouldn't use abbreviations or codes in your spreadsheet as many
newspapers and online readers won't know what these abbreviations stand
for.
You can use Excel's Global Replace feature to transform these abbreviations into easy-to-use text.
For this example, we'll use a spreadsheet with abbreviated degrees and majors:
Here you'll notice that our students have a column labeled
MAJOR
and inside this column we have shortened codes for the degree and major
the person has earned. To convert these columns into standard text,
we'll highlight the column and press
Control+H. This will open up our global replace search box:
We will then choose to search for
BA-COM and replace it with
Bachelor of Arts in Communications as you'll see above. Clicking on the
Replace All button will let us know how many instances of this text has been replaced in our document:
We can then hit
Control+H again do the same thing for the next abbreviation we'd like to replace (
BS-BIO):
After replacing all of the text our spreadsheet will look like this: