+ Reply to Thread
Results 1 to 4 of 4

Strip data from a cell

  1. #1
    Registered User
    Join Date
    10-16-2006
    Posts
    19

    Strip data from a cell

    Hi guys.

    I have exported a load of xml data to Excel and I am getting this:

    <number>1.9</number>
    <number>2.4</number>
    <number>5.8</number>
    <number>-3.6</number>

    What I want to be able to do is get rid of the opening and closing number tag so I get this:

    1.9
    2.4
    5.8
    -3.6

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Replace <number> with nothing
    Replace </number> with nothing

  3. #3
    Registered User
    Join Date
    10-16-2006
    Posts
    19
    Hi shg,

    Thanks for responding so quickly.

    Find and Replace....obvious heh, I was looking for some complicated function!!
    Last edited by mundo; 12-09-2007 at 04:54 PM.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    We all have the occasional blind spot ...

+ Reply to Thread

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