Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Cells containing symbols; deletion problem

20 Sep 2015   #1
rundwald

Home Premium 64 bit
 
 
Cells containing symbols; deletion problem

I have attempted to transfer some data from an on line journey planner to Excel by copy and paste.
No problem arises from the operation, but I want to remove the symbols (see att'd) from the pasted item prior to printing. What is the best way to remove them, please? Will apparent sub-division of the column that contains the symbols have any effect on procedure?




Attached Images
Cells containing symbols; deletion problem-symbol-example.gif 
My System SpecsSystem Spec
.
28 Sep 2015   #2
rundwald

Home Premium 64 bit
 
 

Another source came up trumps.
F5> special > objects > OK
My System SpecsSystem Spec
Reply

 Cells containing symbols; deletion problem




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Character length in a cell or cells
Hi guys, just wanted to ask if any of you can help me out in excel. Basically what I wanna do is, if I copied a text or a sentence and I would want to paste it on a cell, i'd like the cell to remove any characters if it is over than 40 excluding spaces. Any kind of help/advice would be...
Microsoft Office
Locking certain cells from updating
All, I created a five year pro forma financial model for my business. The spreadsheet makes extensive use of worksheet formulas and macros. I also added a sheet to track actuals (numbers extracted, by hand, from QuickBooks monthly). Certain formulas in the spreadsheet are based on values...
Microsoft Office
Problem while copying symbols from charmap to notepad
I am trying to copy some symbols from "Wingdings" font using chamap. When I paste the symbols in notepad (I changed font to Wingdings for notepad) I see unknown rectangular characters. I selected this font from charmap and when I pasted this in note pad I got this: I don't know where I am...
General Discussion
Cells contaning Fri 16 Jul 10 and similar as text
I have a s/sheet ( Excel2007), whose source data was taken from a link. The date column is in the format as per title. In that form it will not sort itself or associated columns in to date order. Has anyone a way to make the data in the column sort itself as I want? Also with the example...
Microsoft Office
Excel un password cells
Hi I have a excel sheet that some cells are password protected i have no idea what the password is any ideas how i can find the password or any software that will find it, so i can change the cell contents. Thanks
Microsoft Office
Vista > Windows 7 Upgrade (file deletion problem)
Hey all, I'm hoping there's a quick answer for this. I'll explain the situation and let me know what you guys think. My friend recently had her computer upgraded to Windows 7 from Vista. She used the Vista StickyNotes program to keep track of important information. I told her that this...
Installation & Setup


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 10:05.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App