Thursday, April 15, 2010

Remove Non Printable Items from Text

To Remove None Printable items from the cell containing text we just have to use a simple formula

=Clean(Cell number)

For Example In cell A1 you have text with some unwanted marks ahead of it just put a formula in Cell B1 =clean(A1) now you will see there are no non printable items are there they are gone now copy this and use past special and past value option your text is there without not printable items

Regards
Hemant
at

2 comments:

  1. Michael LengAugust 10, 2018 at 2:24 PM

    Wow! That's a very good way. I have visited your site, and I like it. Thanks for your share.

    Ctrl + ' (apostrophe) To Fill Cell Formulas Down From The Adjacent Cell Above

    ReplyDelete
  2. Marketing Pro PKAugust 10, 2023 at 12:25 AM

    https://nelsonmstips.weebly.com/blog/how-licensed-microsoft-office-enhances-your-business-operations

    ReplyDelete

Subscribe to: Post Comments (Atom)

Hi Friends, After a long break, I again started to work on this blog with new time-saving techniques and tricks for making the day to day...

  • Web Page from MS Excel
    If you need to analyze data from a Web site, you might be in for a bunch of tedious retyping. Under the right circumstances, however, Excel ...
  • Tips to look more profession in Excel
    Excel provides several underline formats to give your spreadsheets a professional look and to make them easier to read at a glance. For exam...
  • Multiple Row Filters in Same Sheet
    I was working on my data sheet and countered with one problem I required filters in two row ranges on being specific I want the first fil...