If you have a list of data in a column, formatted in a similar manner throughout that you wish to separate into several columns, you can use Excel's Text to Columns feature to separate this information. For example, say your list is in column A and it contains a list of customer email addresses. You want to retrieve just the part before the "@", because that is also their ID … [Read more...]