#1
|
|||
|
|||
Strange character in text copied from excel
I hope you can help with this problem. I copie a large amount of Tagnumbers from an Excel sheet in a Word table. In Word two extra characters show up. The are not printed and also not visable if I hide lay out. But if I copy the tagnumber from Word and paste it in the search field in the Excel sheet were is was retrieved from, Excel cannot find the number anymore. Please see attached file were I marked the character yellow. The excel sheet is an export from Autocad Plant 3D and the character shows on positions left blank. What is the character and why the content changes when it is copied?
|
#2
|
|||
|
|||
Strange... I see what you're talking about I also see that if I try to copy the full text over and over, the mystery characters disappear when pasted. Maybe just copying from Word, and paste back into Word will clean the text(?)
Also, be sure that you're experimenting with the 'Paste as text' feature of Word. |
#3
|
|||
|
|||
I copied it in Word as text and the character disapears. But what bothers me is that I cannot find the Tagnumber in the excelsheet anymore. Which means that the content also changes when copied from Excel to Word.
|
#4
|
|||
|
|||
Have a look at Word’s nonprinting formatting marks
Excerpt from the paragraphs devoted to “Spaces” (near bottom of page): Quote:
|
#5
|
||||
|
||||
One wonders why the Tagnumber in the excel sheet would have these characters...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#6
|
|||
|
|||
Because the Tagnumber can have more characters. These positions are left blank in Autocad. That happens during export to excel. We don't know what happens there.
|
#7
|
||||
|
||||
In that case, it seems to me you have four main options:
1. Leave things as they are. 2. Modify your Autocad export process so the unwanted characters aren't included in the output. 3. Remove the unwanted characters in Excel before doing the transfer to Word. 4. Remove the unwanted characters in Word only.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
strange character in Header | hthayz | Word | 6 | 10-14-2015 09:18 AM |
Extract Line of Text w/ specific characters up to the paragraph character, send to Excel | dmarie123 | Word VBA | 10 | 07-20-2015 12:16 AM |
Making Tables Copied from Excel Fit to Page | joatmon | Word | 1 | 05-30-2012 08:47 AM |
Underlined copied text box | LarryStroup | PowerPoint | 0 | 09-30-2011 11:22 AM |
PP Slide copied text is underlined | LarryStroup | PowerPoint | 0 | 05-20-2011 11:16 AM |