+ Reply to Thread
Results 1 to 3 of 3

Code to recgonize non-numeric "Left"/start of cell in cells of dynamic column

  1. #1
    Registered User
    Join Date
    12-27-2016
    Location
    Kalamazoo, Michigan
    MS-Off Ver
    MS Excel 2013
    Posts
    2

    Code to recgonize non-numeric "Left"/start of cell in cells of dynamic column

    -1
    down vote
    favorite
    I unfortunately have an un-changeable data source which pull data per the image below. My goal is to include within a current macro, code which will recognize all cells within a dynamic column (L) that have a single entry (i.e. do not begin with a numeric value) and add "1. " to the beginning of each. I've been playing around with this for a while and am stumped. Any suggestions?

    Sample

    Column A Column B

    Row 1 Participant Role

    Row 2 1. Participant A 1. Role A
    2. Participant B 2. Role B

    *Basically I would like the code to automatically format any cells with the default value similar to that displayed in "Row 1" to be changed to the numeric format displayed in "Row 2".

    Thanks!
    Attached Images Attached Images

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: Code to recgonize non-numeric "Left"/start of cell in cells of dynamic column

    Give this a try

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Registered User
    Join Date
    12-27-2016
    Location
    Kalamazoo, Michigan
    MS-Off Ver
    MS Excel 2013
    Posts
    2

    Re: Code to recgonize non-numeric "Left"/start of cell in cells of dynamic column

    Awesome, thanks Mike! Much appreciated.

+ 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. Replies: 35
    Last Post: 01-13-2016, 02:16 AM
  2. [SOLVED] Trim left, but only if the first 3 character start with "The"
    By firstsgt1978 in forum Excel General
    Replies: 7
    Last Post: 03-25-2014, 11:47 AM
  3. [SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  4. Replies: 9
    Last Post: 11-06-2012, 08:59 AM
  5. Applying a "Left" formula to an entire column with heading "ValueCol"
    By aad401 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2012, 04:14 PM
  6. Replies: 4
    Last Post: 02-12-2012, 05:46 PM
  7. allow a Numeric only UserForm Textbox to start with a Decimal "."
    By DoriBeE in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-03-2011, 05:48 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