Results 1 to 3 of 3

VBA required to Add some Text before all Numbers

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-12-2017
    Location
    india
    MS-Off Ver
    2013
    Posts
    196

    VBA required to Add some Text before all Numbers

    Hi Friends,
    i have a task to add a Text (QX) before all the numbers in K:K column & ignoring the blank cells,
    Attached the sample excel file.

    example: 00542123 has to be changes as QX00542123

    could someone please help me to provide VBA for this task.

    Thanks in Advance.
    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. Formula Required to add on Numbers as required to other data
    By choccy_77 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-01-2020, 01:16 PM
  2. [SOLVED] Simple Conditional Formating Help Required - If Blank then Red Bold text required
    By thilag in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-19-2014, 12:23 PM
  3. please help!!ALL COMBINATIONS REQUIRED FOR 5-DIGIT NUMBERs using numbers 0-9
    By natasha mirembe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2014, 01:43 PM
  4. Macro required for changing numbers to specific text
    By amolryeolekar in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-18-2013, 01:26 PM
  5. Replies: 11
    Last Post: 12-10-2012, 10:40 AM
  6. Replies: 2
    Last Post: 03-07-2012, 02:31 PM
  7. Help required for changing the numbers into text
    By sajidbagi in forum Excel General
    Replies: 5
    Last Post: 01-03-2011, 12:54 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