Handy Hint: Joining multiple text columns into ONE:
Option1: Using a text formula: CONCATENATE
Enter the following Formula in the Blank Column D:
=CONCATENATE(A7, ” “,B7, ” “, C7)
Explanation: Take the text in Column A, Row 7 followed by a space and the text in ColumnB,Row7, Followed by a Space in ColumnC, Row7 and join them together into this Column where my cursor is currently.
The result: 074 1800764771 C0000036
OR
Option2: Using normal combining of various Columns into one:
Enter the following Formula in the Blank Column D:
=A7&” “&B7&” “&C7
Explanation: Take the text in Column A, Row, add a blank space, add the text in ColumnB,Row7, add a blank space,and add ColumnC, Row7, and place the result where my cursor is currently flashing.
The result: 074 1800764771 C0000036
Copy concatenate formula to all rows in Column
Copy the selected formula to all rows with reconcilable items.
Pasting the VALUES only
Highlight Column D – Right click, select, COPY – and right click, select, Paste Special (Values)
(It will remove the Formula and replace with the merged text)
Time to formulate your Journal
On a new blank worksheet…… Top Left Column and Row
Type : <TABLE> Add Column Headers :
-
- Now copy your columns across from your Worksheet (where you calculated the differences)
- Finish your journal with : </TABLE>
Import into Journals in Winmain and finalize Journal
In Windows Main Module: File \ 
or alternatively select: 
Click on 
Enter the location and file name e.g.: C:\bspdisks\bsp may09jnl.xls Click on 
to import the journal.
Finally click on 
to write the journal in Draft mode to Windows Main Module:
Once the import is complete:
Proceed with the Saving of the journal.