19 April, 2013

Extracting Text In Excel

Excel is actually pretty good at managing text. Suppose you have a string of text containing markers (Name: etc.) you want to divide:
Into:

First use the function FIND to locate the markers in the string of text.

Then use the function MID to pull out text between those locations. You need to account for the length of the markers.

This is great because it doesn't depend on how long the text string is or if there are spaces, etc. For the last string you can use the function RIGHT, for the last few characters, or first use LEN to get the length of the string.

No comments:

Post a Comment