Results 1 to 34 of 34

Replace string with vba

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-20-2019
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    116

    Replace string with vba

    I have strings which vary like:

    1. 12 X 14 SCALE PAPER 21#(5 X1M/CS) 9927

    2. 12 X 18 DRY WAX21LB (1M/BOX)


    3. 12 X 14 DRY WAX SCALE 18LB (1M/BDL/5 BDL/CS) J


    I have to do maths on these which will be like this:

    1. 12*14*21
    2. 12*18*21
    3. 12*14*18

    I am having a hard time using REPLACE/SUBSTITUTE to solve this, because the spaces vary between different cells.

    Suggestions?
    Last edited by diyVBA; 03-16-2020 at 01:41 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Replace Characters to Left of a String with Another String/Character
    By stevoDE in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-06-2019, 02:43 AM
  2. how do I replace a string within a string in an array
    By dschmitt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-14-2015, 02:30 AM
  3. [SOLVED] Need help with REPLACE function to replace HEX A0 with HEX 20 in string
    By flyboy54 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-26-2013, 12:52 PM
  4. [SOLVED] Replace string with another string from another worksheet (like decode)
    By sugee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2013, 02:05 AM
  5. [SOLVED] Find a string by VBA Regular Expression and replace a part of that string
    By taps in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-25-2013, 11:08 AM
  6. How to Assign Value to a String & Replace String With Assigned Value?
    By xiaokang1982 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2012, 06:01 PM
  7. Replies: 3
    Last Post: 08-10-2006, 07:20 PM

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