Results 1 to 15 of 15

Thread: VBA from text to number

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 10-15-2019, 08:18 AM #1
    Sophia
    Sophia is offline
    VBAX Regular
    Joined
    Oct 2019
    Posts
    14
    Location

    Lightbulb VBA from text to number

    Hi Guys,

    I need to crete macros to exctract (1) and (702) numbers without brakets from this text, converted it to 702_1 format and change sheet name to 702_1 automatically.

    text is on the same sheet which need to be changed. (several sheets like that not one)

    current sheet name is Sheet1, Sheet2,...

    No other numbers in text

    Is it possible?
    Last edited by Sophia; 10-15-2019 at 08:41 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules