+ Reply to Thread
Results 1 to 2 of 2

Imported Data Formatting Issue

  1. #1
    Registered User
    Join Date
    06-24-2015
    Location
    Atlanta
    MS-Off Ver
    13
    Posts
    8

    Imported Data Formatting Issue

    I have a ton of data that is imported from our company's website. The data is displayed like this though "$100.00 (4 payments)". I need the dollar amount in this example, and in others I need the parenthesis data. I have tried using the Left() and Right() functions, but because nothing is static--some dollar amounts can be up to five figures--this does not work.

    It would be fine if I could input the data as is, ie "$100.00 (4 payments)", in a chart or graph, but that is not possible. Any suggestions on how to do this with VBA?

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Imported Data Formatting Issue

    Hi mwhite18

    You may well be able to use the Split Function available in VBA. Please mock up a file of some dummy data that's representative of your actual data and attach that file. I'll look at it.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto formatting of imported data
    By mickinho in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2013, 10:53 PM
  2. Formatting Imported Data After a Refresh
    By ctrapper in forum Excel General
    Replies: 0
    Last Post: 01-04-2013, 11:39 AM
  3. [SOLVED] need vba formatting help!!! this is imported data that needs to be re-formatted!!!
    By julienaas in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-27-2012, 03:08 PM
  4. Imported data not formatting as time
    By cooksteve09 in forum Excel General
    Replies: 2
    Last Post: 05-16-2012, 07:28 AM
  5. Formatting on imported data (Excel 2003)
    By Marsha in forum Excel General
    Replies: 0
    Last Post: 07-25-2006, 03:20 PM
  6. Formatting imported data
    By Jsb in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-26-2006, 06:55 PM
  7. [SOLVED] Formatting web imported data correctly
    By Bob Smith in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-23-2005, 11:15 AM
  8. Conditional formatting with imported data
    By stephenfu1@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2005, 11:06 AM

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