Excel Tips - Remove unwanted characters

Hi, can anyone advise me how to remove unwanted characters such as comma, space etc. from an excel sheet. Please see a sample below.
2, 2, 3, 2, 1, 3, 2, 1, 1, 3, 1, 1, 1, 3, 2, ,1 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,

I am looking for a formula that will remove any unwanted characters in a cell.

For example i may a word or string of words with "-" , " ' " or "," in them and i would like to have these removed.

Thanks,
Adam.

Thanks in advance for anyone who can help me with this problem.

I am trying to export some data to my website using mysqlcc. I have my spreadsheet setup so that I can simply copy the data from excel (2000) and paste it into mysqlcc.

As far as I can tell there is nothing at all wrong with the data or the formulas, but when I paste into mysqlcc there are unwanted quote characters, 1 at the beginning and 1 at the end. This throws off my sql syntax and of course the insert fails. It will also paste that way into a text editor I use.


There is one cell which contains the insert into statement in which I have quite a bit of concatenated data from probably 10 or so columns. I have narrowed it down to one in particular which is the sales narrative. There is nothing particularly unusual about this data (aside from the fact that it has quite a few characters. I removed pieces of the data to see where it fails, and did find that after taking some of the data out it would work, but there is nothing unusal at all about the data which was removed. None of this makes any sense at all. So, to make a long story short, sometimes when I paste from excel the quotes show up and other times they do not, and there seems to be no rhyme or reason to this behaviour.

I should also mention that when viewing the cell the beginning quote is nowhere to be found. The contents are too long to be able to really tell about the end quote, but there is no reason to suspect anything different for that.

Has anyone else here ever run into a similar situation and/or happen to know what is wrong here? I'm about ready to start banging my head against the wall here.

I can post an example of the data if need be.

Thanks again if you can offer any insight.

Hello Everyone

want to deleted hidden rows from excel spreadsheet.

Want to delete data in excel sheet , screen shot of excel for reference in the below case i dont require highliged in green colour, only require the data in black colour, its just a sample date in the same manner having around 50 pages of data in similiar way in sheet 1, after end of every page first the highlighed data comes and then the excel table , i am concerned only with table.
is it possible to delte all the data highligted in green colour and then data in black colour should be in one page also there are unwanted space between the data wan to delete that also.

Please provide some solution for the below.

304. Counterparty Exposure and Collateral Positions For Valuation Date: 10 May 2010 Counterparty: Agreement ID: This margin, collateral or securities (*margin*) statement is provided to you at your request or in accordance with documentation between us. All margin owed must be provided as and when required in accordance with the documentation. Although the information in this statement has been prepared in good faith and based upon sources, materials and systems that we believe to be reliable, we cannot guarantee it's completeness or accuracy. We reserve the right to amend the statement and notify you of different amounts.
This statement is provided to you for your information only, is not intended to satisfy any obligation that you may have under applicable law or regulation to establish or determine market valuations and does not constitute advice by us with respect to market valuations. Nothing in this statement should be construed as an offer, or a solicitation of an offer, to buy or sell any security or other instrument at a stated price.
If you have any questions or wish to check any calculations, please telephone the Collateral Management Unit on .
* Other Equity Cash comprises realised gains or losses, unpaid dividends and commissions. Printed: 10 May 2010 01:33:59 Standard Format Page 1 of 50 304. Counterparty Exposure and Collateral Positions For Valuation Date: 10 May 2010 Order Number TCN Trade Date Maturity Date Exposure (USD) Product Notional Ccy Initial Margin IM Ccy 0 2534935-ETL 01-Feb-2010 30-Apr-2010 55,396.52 Basis Swap -50,000.00 USD 0.00 USD 0 2777262-ETL 10-Mar-2010 30-Jun-2010 18,931.86 Swap -50,000.00 USD 0.00 USD 0 2777263-ETL 10-Mar-2010 31-Aug-2010 -16,346.69 Swap 50,000.00 USD 0.00 USD

Dear friends,

I have an excel sheet with a codes and in beteen the codes there are dots, comas etc... i wanted to remove this from the column. Can anyone help me on this? Please see the sample of the excel sheet below.

Regards,

Prathap

CURRENT FORMAT REQUIRED FORMAT 010.0210- 0100210 010.0310- 0100310 010.0510- 0100510 010.0610- 0100610 010.0710- 0100710 010.0910- 0100910 020.1130-191 0201130191

hi,

i have quite a lot of excel 2003 spreadsheets which once edited and saved by excel2007.

now, i'm using back excel 2003.

(because my efficiency dropped by half by searching the command i wanted in excel2007.)

when i open them with excel2003 again, there are a lot of styles.

i want to remove them.

but it is a tedious job to remove them one by one for these spreadsheets.

i tried style manager add-in. but it didt help at all.

is there any quick way to do it??

thanx for reading.

regards

I have a multi-column spreadsheet in Excel 2003 - produced daily - which updates on a line by line basis the months sales activity. Included in this spreadsheet is a column displaying account numbers. Is there a method whereby I can run a macro to remove a specific account number so that I don't have to manually highlight and delete the lines of data which contain this account number?
Any help would be welcome. Thank you. Billph.

I have this huge speadsheet that is updated all the time.
Sometimes number are formatted like this: "1234.567-8901" but I want it to display the number without any other characters in it like "12345678901"

I was thinking of an if statement with nested MID functions to locate the characters, but how do I take the "." and the "-" out without doing it manually?

Hello,

I have tried hard to no avail using the trim function to get rid of the unwanted characters before and after the numbers below :

<---- 17026 ---->
<---- 17027 ---->
<---- 17049 ---->

Any one with any ideas?

Many thanks

FO

I've been using excel 2008 on a mac, but the end user of the file is going to be on a PC. When the file opens in excel 2007 on the PC there are a lot of unwanted characters that show up, they show up as a box, as though there are spaces behind, but there are not. I have enclosed a screen shot. Any ideas on how to remove these without going through each cell individually?