| |
|
|
A Square Symbol is displayed instead of a carriage return in Excel
When a user is trying to export a Notes field containing multiple values into one single cell in Excel (as in FAQ 0060) the values are separated with a "square" symbol in Excel.
Excel uses the square symbol to represent a carriage return when the text in the cell is not set to wrap.
To resolve this you need to perform the following steps:
- Open the Integra profile and edit the Excel template
- Select the cell to contain the multiple values
- Right click on the cell and select "Format Cell"
- In the new dialogue box displayed click on the "Alignment" tab
- Under the section "Text Control", enable the option "Wrap text"
- Click on "OK", Save & Close the template and update the Integra profile
|
. |
|
FAQ# 0231
|
|
|
| |