How to prepare data in Microsoft Excel

Microsoft Excel and other spread sheet programs are knwon to be able to read many data types, however, sometimes this data is interpreted differently that desired. Below are tips to convert/ process data in spread sheets after import and prior to further processing in the Tygron Platform.

Removing spaces and other characters in bulk from ranges of cells

Sometimes extra redundant spaces or other characters are found in (imported) cells that hinder proper interpretation of the cell value. By using the search and replace functionality this can be dealt with.

How to remove redundant spaces from imported data in Microsoft excel:

1. Select the cell (range) affected
2. Select Start
3. Select Edit > Replace
4. Enter a space in the search field
5. Leave the replace field empty
6. Select Replace All

• 

  1. Select the cell (range) affected

• 

  2. Select Start

• 

  3. Select Edit > Replace

• 

  4. Enter a space in the search field

• 

  5. Leave the replace field empty

• 

  6. Select Replace All