Results 1 to 3 of 3

Numbers and text together in column

Threaded View

  1. #1
    Registered User
    Join Date
    08-31-2009
    Location
    Doha,Qatar
    MS-Off Ver
    Excel 2007
    Posts
    1

    Post Numbers and text together in column

    Dear all,

    Could someone please help me to remove the texts, punctuation marks, i.e; hyphen's, slashes, colon etc from a particular column and get me only the numbers?

    I'm an accountant by profession. If i could do this task in a jiff, i could have saved some time for other works as well.

    Attached is the sample sheet for your kind reference.

    Please help

    The numbers that we see in Column C is very mandatory. These are the Receipt numbers and that's exactly what i need. I do not need these texts along with it....neither the punctuations..

    Thanks
    amey
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1