Having problems with your PC Desktops ?

I have a column of 13000 cells containing id numbers. i want to format the entire column in numbers and eliminate the - (dash) who to do it


Answers :

I presume you are talking about Excel, but the process is similar in many other programs.
\015\012
\015\012First make sure you have a backup copy of the file just to be safe. The do the following.
\015\012
\015\0121. Higlight the cells you want to remove the dashes from (or the entire columnn if easier)
\015\012
\015\0122. From the Edit Menu select Replace
\015\012
\015\0123. Put a single dash in the the Find What: box and leave the Replace With box empty.
\015\012
\015\012Note: This will search the selected range of cells for dashes and replace them with nothing.
\015\012
\015\0124. Select Replace All and give a second and your done.
Repair Help & Product Troubleshooting for PC Desktops

Tips for a great answer:

- Provide details, support with references or personal experience .
- If you need clarification, ask it in the comment box .
- It's 100% free, no registration required.

Suggested Questions/Answers :

I have a column of 13000 cells containing id numbers. i want to format the entire column in numbers and eliminate the - (dash) who to do it


I presume you are talking about Excel, but the process is similar in many other programs.\015\012\015\012First make sure you have a backup copy of the file just to be safe. The do the following.\015\012\015\0121. Higlight ... PC Desktops

Cannot insert columns in excel spreadsheet. Comes up with error cannot shift object off sheet


This error message occurs if the following conditions are true:\015\012\015\012\015\012The option Nothing (hide objects) is selected in the Display options for this workbook section in the Excel Options dialog box. ... PC Desktops

My MS Excel vlookup function ASCII type table contains both upper case and lower case letters, characters like ( and % or *, and numbers. It seems to return the numerical equivalent of upper case letters only, not the lower case, and fails on numbers, returning #N/A. The upper case letters and most of the other characters work properly.


Correct a #N/A error\015\012\015\012\015\012Show All\015\012 ... PC Desktops

I got an acer laptop and it had a password on it but i dont know the password what do i do?


Dear pauline_mcil,Right then, this is going to depend on whether you have any of the following three types of passwords, which are :- 1) BIOS/ CMOS password --- used to protect the actual computer hardware and settings from security ... Acer Aspire 5315 Notebook

IP Phone Hi, have access to free internet via WLAN ( Realtek RTL8187 device) also have IP phone that use DHCP. Q: Can the DHCP be routed to the LAN port on the laptop so I can connect IP phone ? any software to solve this ?? Laptop : Compaq Armada E500, XP HE BR Formulapro


I am not sure Y\015\012want to go thru all the trouble of routing an IP or headset, when there R much\015\012simpler J\015\012and free or VERY low-cost ways of calling via online providers, even though\015\012t ... PC Laptops

Gateway Computer .


To unhide th column. \015\012click on the upper most left corner (the box on top of the row1 and column c). the enter spreadsheet should be highlighted. then go to format>>unhide. you should have the column A and ... PC Desktops

Computer has frozen on windows logo


1) Which version of Windows ? For the following discussion I am assuming it is 2000, XP or higher. You may also want to print this, it's long.2) Is this this the low resolution Windows logo on the black scre ... Fujitsu Siemens SCALEO 600 (FSP:83C005617) PC Desktop

DST Short Status Test Fail Error Code 1000 0146


DST (Drive Self Test) failed. this simply means that the drive is no longer stable. If you are unable to boot to windows or safe mode and this is the error you get you might need to do a low level format if you still want to use it or do a debug scri ... Dell Inspiron E1405 Notebook

HDD Partition help


Important If you follow these steps on a hard disk that is not empty, all the data on that hard disk is permanently deleted. We recommend that you back up your hard disk before you follow these steps.To partition and format your hard disk by us ... PC Desktops

I can't send or recive e-mail using 2003 outlook, Trying to set it up so I can access my aol account but I am also using a local service to get the internet. I am getting error codes 0x80040900 and 0x800CCC01 any ideas


Did you try to setup the aol account properly...\015\012these are instructions as per microsoft:\015\012\015\012 ... PC Desktops

Computer crashes on startup, goes to system repair


What you need to do is first try pressing F8 when the machine first boots, this will put you into safe mode, when it comes up choose Safe Mode with networking. When it comes to the point asking you to choose system restore or safe mode desktop choose ... Acer Aspire 5920-6335 Laptop

Our computer is so slow lately. It takes ages for it to respond to a comand. There is no apperant reason for it. Could it be that there are different programs hindering each other? I am very new to the computerworld, so excuse my naive way of discribing the problem. Thank you so much in advance! Gaby


Well there is many causes slow your pc do this steps:Remove any programs you donot use it .donot install more than 1 anitvirus program on ur computer.delete cookies and temporary files.change the virtual memory size, give it t ... PC Desktops

My computer has viruses and I need to reset my whole computer before it crashes. I've tried to delete the viruses but I have to pay for the services, which I can't afford at the moment. I have a Compaq computer and I wanted to know exactly how to reset it. Any advice?


Before formatting the computer ( what you call ' resetting ' ), try a combination of FREE anti-malware and antivirus products. In combination and with deligence on your part, I'm almost certain you will see a huge improvement in your system operation ... PC Desktops

Gateway MX6455 - AMD Turion 2.0Gb with 1Gb Ram Stops working and goes to black screen after POST. Will not boot into windows. The more I try re-booting, the faster it stops.


Try to FORMAT your devices If your using XP use the tutorials below:\012How to partition and format the hard disk using the \012Windows XP Setup program\012\012 loadTOCNode(2, 'moreinformation');\012 You can use the Wi ... PC Laptops

Format - PC Laptops


How to partition and format the hard disk using the \012Windows XP Setup program\012\012 loadTOCNode(2, 'moreinformation');\012 You can use the Windows XP Setup program to \012partition and format the hard disk. To do this, ... PC Laptops

Connecting a Dell Latitude D630 Laptop with an HP LP2465 monitor


The Dell Latitude D630 has a 15 pin VGA port that can connect to an external monitor or projector. For detailed information go to www.support.dell.com and select "I'm ... Dell Computer Monitors

Converting Partition to ntfs


Converting to NTFS\015\012\015\012Your hard drive must be formatted with a file system such as FAT, FAT32 or NTFS so that Windows can be installed on to it. This system determines how files are named, organised and stored on the drive. If you&r ... PC Desktops

Problems with installation


The main problem with installing Windows XP on an Acer 4310 notebook always comes back to the wireless lan. You will oftentimes see an error code 39, and be told that the driver is corrupt or missing. The problem with the wifi card seems to be spec ... PC Laptops

How to install xp in HP Pavilion dv6 1030 us Laptop and how to repartition my C: drive especially I have still 150 GB free space in C drive Please help me in this case Thanks in advance.


Partition and format the hard disk using the Windows XP Setup program\015\012\015\012 loadTOCNode(2, 'moreinformation');\015\012 You can use the Windows XP Setup program to partition and format the hard disk. To do this, use ... HP Pavilion dv6-1030us Notebook

Merging 2 columns in excel of names example F1592&H1592 IN COLUMN G1592 SUE JONES


You need to go into format cells and then merge them together and you should be just fine. Highlight the cells that you wish to merge and then right click and then click on format cells and then merge cells together. ... PC Desktops

Rebuild a poweredge 4400 with nt4


You in the correct area you first delete all containers then re do the scsci drives follow the menu space to selct the drives then you inisalize not format if you format each drive you will be workng for hours on format make the containers then let ... Dell PowerEdge 4400 Server

MY E DRIVE HAS DISAPPARED FROM MY COMPUTER (LAPTOP) AND I CAN NO LONGER USE THIS - NOT READING WHEN INSERTING DISCS EITHER. LAPTOP IS ACER - AND INFO FROM DEVICE MANAGER REGARDING THE E DRIVE IS AS FOLLOWS: OPTIARC DVD RW AD-7530A ATA DEVICE DEV TYPE DVD/CD-ROM DRIVES MANU STANDARD CD-ROM DRIVES LOC LOC 0 CHANNEL 1, TARGET O, LUN 0 THE ERROR MESSAGE READS: Windows cannot start this hardware device because its configuration information (in the registry) is incomplete or damaged. (Code 19) Click '


The following worked perfectly in restoring the CD-ROM drive:The following steps were posted by skidzy on the pcadvisor.co.uk forum: ... PC Desktops

How I open my widows by protected password - PC Desktops


You will have to remove the hard drive and back up all the files you wish to save. You can do this with a 7 dollar USB hard drive adapter cable from E-Bay. Save your files on another computer. You then have to be able to boot the compute ... PC Desktops

Packard Bell EasyNote Booting Problems (Bluntly)


Packard bell 1935 hdd password ... Packard Bell Easy One Silver 2101 Notebook

Keep getting CODE 19 for dell 1000 cd rw/dvd


Follow these directions for clearing the Upper/Lower Filters: (might want to print this out)1. Click on Start --> Run --> and type in 'regedit' followed by the enter key ( if Vista Start search or windows+R )2. Expand the "HKE ... Dell Inspiron 1000 Notebook
  • Start your question with What, Why, How, When, etc. and end with a "?"
  • Be clear and specific
  • Use proper spelling and grammar
all rights reserved to the respective owners || www.electronic-servicing.com || Terms of Use || Contact || Privacy Policy
Load time: 0.5585 seconds