Results 1 to 8 of 8

Manipulating strings

Threaded View

  1. #1
    Registered User
    Join Date
    12-21-2016
    Location
    London
    MS-Off Ver
    2016 Professional
    Posts
    3

    Manipulating strings

    Hello,

    I want to manipulate strings of text/numbers. See attached my spreadsheet.

    If part of the string has one number in parentheses e.g. A(1), that can be left as it is. For parts with more than one number e.g. F(1,100,200), I want this broken down into F(1),F(100),F(200).

    The "Original" is my string currently and "New" is what I want it to finish as.

    I have hundreds of such strings so it cannot be done manually. Any suggestions/assistance will be appreciated.

    Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Manipulating Strings in VB
    By hvincent in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2014, 01:36 PM
  2. Manipulating strings in VBA
    By Mordred in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-27-2010, 01:36 PM
  3. Manipulating strings
    By therealjag in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2010, 08:32 AM
  4. Manipulating Text strings
    By xmoore in forum Excel General
    Replies: 13
    Last Post: 01-15-2010, 07:16 AM
  5. Manipulating Strings
    By OlYeller21 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-06-2009, 02:08 PM
  6. Manipulating strings in two columns
    By osalcido in forum Excel General
    Replies: 2
    Last Post: 03-05-2007, 08:41 PM
  7. [SOLVED] Manipulating Strings
    By Leslie Coover in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2005, 02:05 AM

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