Listers, I'm trying to open an excel spreadsheet in MapInfo but I'm having a problem with a couple of the fields. One is created by concatenating 5 other columns =CONCATENATE(N13," ",O13," ",P13,"/",Q13,"/",R13) and the other is using the Text function =TEXT(H7,"dd-mmm"). When the spreadsheet is opened in MapInfo these two columns are empty.
One way round this is in Excel, copy the column and use the paste special option to paste the values into the column, replacing the formula. This works but I just wondered if there was a way of opening the spreadsheet in MapInfo without having to do anything prior in Excel. Thanks Greg Driver Corporate Data Officer Ext. 2292 Internet communications are not secure and therefore Surrey Police does not accept legal responsibility for the contents of this message. This email and any attachments may be confidential. They may contain privileged information and are intended for the named addressee (s) only. They must not be distributed without our consent. If you are not the intended recipient, please notify us immediately and delete the message and any attachments from your computer, do not disclose, distribute, or retain this email or any part of it. Unless expressly stated, opinions in this email are those of the individual sender, and not of Surrey Police. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking. Surrey Police reserves the right to monitor all email communications through their networks.
