Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

How do I remove text qualifiers from imported data?

I would like to transfer data into Excel without Excel assigning a text
qualifier. I know it can be done, but I don't know what setting needs to be
changed in Excel, so the text qualifier is absent until I choose to utilize
it.

Version: Excel 2002


Post your answer or comment

comments powered by Disqus
How Do I Remove a Password from a Workbook in Excel 2010?

I have an Excel 2003 workbook. I have added a shadow to a cell using the Drawing Toolbar. When I go back to remove the shadow, the "No Shadow" option is grayed out. What's up? How do I remove the shadow from the cell?

I have a massive spreadsheet that I need to add formulas to but the cell from
which I need to contruct the formulas from has a contant and the formulas do
not work how do I remove the constant?

I have a worksheet that has info that was ported from a pdf file. The cell
has a reference that would give additional info. I do not need it there.
How do I remove reference to additional info?

how do i remove hyphens from between numbers witout having to edit manually I
have a column of 3000 numbers similar to below.

0-7643-2200-1 becomes 764322001

0-7643-2299-X becomes 076432299X

if i format the column as text and then use the search and replace dialog
box Ctrl-H search for hyphen and replace with nothing it works on numbers
which end in a letter ie -X but will remove the 0 at the beginning of numbers
not ending in a letter ie -1 in my example

Can anybody help
Thanks Ian

How do I remove the page number from the "page break preview" and yet keep it
in the "page break preview" format? I just want to remove the watermark only.

I am pasting numbers into a spreadsheet, however its treating them as text
because there is a space before the number. How do I remove the space so it
treats it as a number ? I have used the =trim() function and its not working.
Thanks for any help !

How do I remove the leading 1 from a nine digit telephone #'s stored in a
column in excel. Eg. Get 17035551212 to be 7035551212

How do I remove all text to the left of the @ in an email address? I have a
column with email addresses and I want to create a new column with just the
text that is to the right of the @ symbol. In other words,

In Office 2003, how do I remove the large "Page #" from the background of the
onscreen display in an Excel spreadsheet?

In Office 2003, how do I remove the large "Page #" from the background of the
onscreen display in an Excel spreadsheet?

how do I remove data from cells ex. (232)-555-1212 to 2325551212

How do I remove all text to the left of the @ in an email address? I have a
column with email addresses and I want to create a new column with just the
text that is to the right of the @ symbol. In other words, somebody@msn.com
is the existing data and I want to create a new column with just the msn.com
string.

How do I remove the page number from the "page break preview" and yet keep it
in the "page break preview" format? I just want to remove the watermark only.

I am trying to get rid of "fix" as it appears next to the NUM & SCRL
indicators on the bottom right hand side of the screen. How do I remove FIX???

I pasted a web page into a spreadsheet, then when I tried to remove it I
could delete all except the flash objects. How do I remove them?

I have a spreadsheet where a default in a field is changed by a double
click. A second double click will return the field to the default.

I only need the field to show the 'default' or the 'alternate' entry.
No other entry is needed.

How do I prevent an operator from entering text?

Thanks,

Robin Chapple

I have deleted a worksheet I no longer need, however the name of the file
stays on the 'file menu drop down list'----How do I remove it from the list???

After entering a formular into a cell. The formula works but the cell shows
"#VALUE! and if the cell is not used it prints value on the page.
How do I remove #VALUE
Please

Somehow I accidentally put a check box in a cell on a excel worksheet. How do
I remove the check box?
--
nikitia

I have data exported from a defect management tool (that reports all the defects that have been recorded in the defect management system). This data has unique columns for name of originator, defect ID, date originated, priority, etc.

The date originated column has the date and time. I want to create a report that tells me how many High, Medium and Low priority defects were created on each date - and I am using a pivot table to do this.

However, because the date column is actually the date and time the defect was reported/recorded, the time element of this is making all the dates unique eg, I have three defects recorded on 29/01/2009, a High priority defect (reported at 29/01/2009 12:23) and two Medium priority defects (reported at 29/01/2009 13:02 and 29/01/2009 13:32). My pivot table is showing each date as a unique date - with a count of 1 against each, whereas I want to see 1 date entry (for 29/01/2009) with a count of 1 against High and 2 against Medium.

I have tried custom formatting the date column to dd/mm/yyyy - which appears to work in the data (but doesn't in the pivot table, because the time stamp is still there, just not visible).

I have tried copy and paste special [Values] (on the custom formatted date column) - but the time stamp is still there.

I have tried formatting the date column to "General", but this changes the dates to the number format - eg 29/01/2009 12:23 becomes 39842.5166203704.

I have tried inserting a new column and using the =Left function for the first 10 characters of the cell (ie the 29/01/2009), but that gives the first 10 characters of the number form of the date, ie 39842.5166

Basically, without going into every date cell (and I have thousands) and manually deleting all the times, how do I quickly change the date column into just having the date in it (ie how do I strip off the time element)?

Many thanks.

If I have an array, how can I remove a string from it?

Here is an example:

Now, if I wanted to remove "C City" from that Array, is it possible?  or do I have to re do the whole array?  

Just one more Point, I will not know where in the Array does "C City" rest? It could be the first or the third, or any spot.

Guys,

This come up with me recently. How do I remove the space at the end of number?

EX: 29.15space

I'm thinking of using the "Replace" from the Edit menu. I just can't remember how to do it.

Can someone remember how to it?

I can't add the numbers because of the space.

I am trying to get rid of "fix" as it appears next to the NUM & SCRL
indicators on the bottom right hand side of the screen. How do I remove FIX???


No luck finding an answer? You could always try Google.