| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I delete the "=" from a cell to give me the phone number I.
I have some data that I copied off a website and pasted into an excel
spreadsheet but I do not get the value that is displayed on the website. For example.... The information that was copied was a phone and fax number 1-555-555-5555 but when I put this information into my excel sheet I get -4500. If I look into the cell the cell looks like =1-555-555-5555. I need a way to remove the "=" from each one of these cells. Thank You, |
|
#2
|
|||
|
|||
|
Hi, what I do in cases like this is to paste the info into Word first, do a
replace - stripping out the = sign and then copy and paste into exel. hope this helps, Mike "jbsand1001" wrote: I have some data that I copied off a website and pasted into an excel spreadsheet but I do not get the value that is displayed on the website. For example.... The information that was copied was a phone and fax number 1-555-555-5555 but when I put this information into my excel sheet I get -4500. If I look into the cell the cell looks like =1-555-555-5555. I need a way to remove the "=" from each one of these cells. Thank You, |
|
#3
|
|||
|
|||
|
Select your data and press Ctrl + H.
Find What: = Replace With: leave empty<< Click "Replace All". HTH Jason Atlanta, GA -----Original Message----- I have some data that I copied off a website and pasted into an excel spreadsheet but I do not get the value that is displayed on the website. For example.... The information that was copied was a phone and fax number 1-555-555-5555 but when I put this information into my excel sheet I get -4500. If I look into the cell the cell looks like =1-555-555-5555. I need a way to remove the "=" from each one of these cells. Thank You, . |
|
#4
|
|||
|
|||
|
Go to ToolsOptionsTransition and uncheck the "Transition Formula Evaluation"
and "Transition Formula Entry". This is the cause of your problem to start with and further imports should work properly without making changes after the fact. Gord Dibben Excel MVP On Thu, 10 Mar 2005 07:47:05 -0800, "jbsand1001" wrote: I have some data that I copied off a website and pasted into an excel spreadsheet but I do not get the value that is displayed on the website. For example.... The information that was copied was a phone and fax number 1-555-555-5555 but when I put this information into my excel sheet I get -4500. If I look into the cell the cell looks like =1-555-555-5555. I need a way to remove the "=" from each one of these cells. Thank You, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you delete a cell then shift cell up? | Excel Discussion (Misc queries) | |||
| Triangle symbol in cell. What does it mean. How do I delete this | New Users to Excel | |||
| Delete Cell Value Based on Another Cell T or F | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| How do you delete one cell from a range of protected cells | Excel Worksheet Functions | |||
Linear Mode
