Results 1 to 6 of 6

removing paranthesis from text in a cell

Threaded View

pani_hcu removing paranthesis from... 06-30-2010, 07:09 AM
teylyn Re: removing paranthesis from... 06-30-2010, 07:17 AM
pani_hcu Re: removing paranthesis from... 06-30-2010, 07:27 AM
teylyn Re: removing paranthesis from... 06-30-2010, 07:38 AM
pani_hcu Re: removing paranthesis from... 06-30-2010, 08:00 AM
martindwilson Re: removing paranthesis from... 06-30-2010, 08:22 AM
  1. #1
    Forum Contributor
    Join Date
    10-11-2008
    Location
    Chennai,India
    MS-Off Ver
    2007,2003
    Posts
    123

    removing paranthesis from text in a cell

    Hi All,

    I want to remove parenthesis from the numbers in the cell. then i will separate the two numbers in two different cells. My data look like this:
    A1
    9520 (8900)

    desired format

    A1 B1
    9520 8900


    Is there any way to remove the parenthesis and separate the two numbers.

    This would be great help to me....

    Thanks in Advance..

    With Sincere Regards,
    Upananda
    Attached Files Attached Files
    Last edited by pani_hcu; 07-02-2010 at 01:51 AM.
    Upananda

Thread Information

Users Browsing this Thread

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

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