+ Reply to Thread
Results 1 to 3 of 3

Bulk selected cells into numeric HTML?

  1. #1
    Registered User
    Join Date
    02-09-2022
    Location
    London, England
    MS-Off Ver
    2019
    Posts
    7

    Bulk selected cells into numeric HTML?

    Hi,

    Not sure if this is doable, but thought I'd ask regardless.

    I currently have the below macro - this converts the text inside the cells (separated by lines) into bullet points.

    Sub aTest()

    *** Dim rCell As Range, spl As Variant, i As Long

    *** For Each rCell In Selection

    ******* spl = Split(rCell, Chr(10))

    ******* For i = LBound(spl) To UBound(spl)

    *********** spl(i) = Chr(60) & "li" & Chr(62) & spl(i) & Chr(60) & "/li" & Chr(62)

    ******* Next i

    ******* rCell = Join(spl, Chr(10))

    *** Next rCell

    *** Selection.ColumnWidth = 200

    *** Selection.EntireRow.AutoFit

    *** Selection.EntireColumn.AutoFit

    End Sub


    Please can someone see if I'm also able to turn it into numbers, like the below?
    1. Test
    2. Test
    3. Test

    Thank you!

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016
    Posts
    3,389

    Re: Bulk selected cells into numeric HTML?

    Hi,

    Does the "ol" switch do what you need?

    Please Login or Register  to view this content.
    Or do you want the numbers as part of the string?

    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    02-09-2022
    Location
    London, England
    MS-Off Ver
    2019
    Posts
    7

    Re: Bulk selected cells into numeric HTML?

    Quote Originally Posted by sweep View Post
    Hi,

    Does the "ol" switch do what you need?

    Please Login or Register  to view this content.
    Or do you want the numbers as part of the string?

    Please Login or Register  to view this content.
    Thank you so much! It was the first one I needed. This works perfectly.

    You have saved me a lot of time manually adjusting it today. Really appreciate it.

    Have a fab rest of your week.

+ 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. Bulk Text Macro - Require Assistance in seperating each line in HTML
    By JackBTM in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2021, 06:48 AM
  2. Modify html data in Bulk using Excel
    By cjawadz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-15-2019, 01:20 AM
  3. How to save selected columns as html
    By Pagz in forum Excel General
    Replies: 1
    Last Post: 12-07-2015, 05:29 PM
  4. [SOLVED] Sum of numeric values within cells also containing non-numeric characters
    By Mike Brewer in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 04-24-2013, 09:16 AM
  5. Removing Non-numeric characters from selected cells
    By glen.comerford in forum Excel General
    Replies: 1
    Last Post: 11-21-2010, 04:14 PM
  6. Mass Changes to Selected Numeric Range
    By ken mossman in forum Excel General
    Replies: 5
    Last Post: 12-27-2009, 08:53 PM
  7. Percentage Change to Selected Numeric Range
    By ken mossman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-27-2009, 07:28 PM

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