ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Paste error from Query (https://www.excelbanter.com/excel-discussion-misc-queries/128907-paste-error-query.html)

GrahamV

Paste error from Query
 
Hi

Not sure if this an excel or query problem

When pasting a query into excel, data is moved to different columns.
This occurs where there is a minus or hyphon in the data

e.g. 'CBR 600 F (M-W)' or '-99'

First thought is that the symbol is acting as a deliminator but I can't find
a solution to prevent this.


Any help would be much appreciated
Graham


All times are GMT +1. The time now is 07:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com