+ Reply to Thread
Results 1 to 4 of 4

VB Code to delete extra characters in Last Name of employees

  1. #1
    Forum Contributor
    Join Date
    01-31-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    193

    VB Code to delete extra characters in Last Name of employees

    Hello:

    I need VB Code to do following.

    Assume:
    B2 = Peek A, Andre D

    where Peek A is Last Name and Andre D is First Name

    I need Code to give
    B2 = PeekA, Andre D

    So basically, need to remove space between any character in Last name before ","

    Please let me know if you have any questions.
    Thanks.

    R
    Last edited by rmomin; 06-23-2022 at 07:57 PM.

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: VB Code to delete extra characters in Last Name of employees

    Please Login or Register  to view this content.
    Experience trumps academics every day of the week and twice on Sunday.

  3. #3
    Forum Contributor
    Join Date
    01-31-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    193

    Re: VB Code to delete extra characters in Last Name of employees

    Hello:

    Thanks jolivanes...It works

    R

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: VB Code to delete extra characters in Last Name of employees

    Thanks for letting us know.
    Good Luck

+ 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. [SOLVED] delete 3rd character if code 6 characters
    By makinmomb in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-30-2016, 03:21 AM
  2. [SOLVED] Extra space or spaces in Text in Forum Post. BB Code for extra space ?
    By Doc.AElstein in forum The Water Cooler
    Replies: 21
    Last Post: 03-02-2016, 02:59 PM
  3. [SOLVED] add extra characters to duplicate text
    By saintsphan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2012, 09:51 AM
  4. [SOLVED] check for duplicates and add extra characters
    By saintsphan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-21-2012, 03:32 PM
  5. Delete extra characters within a cell
    By catfish252 in forum Excel General
    Replies: 5
    Last Post: 04-05-2007, 03:26 PM
  6. Replies: 6
    Last Post: 06-21-2006, 11:25 PM
  7. [SOLVED] Stripping Extra Characters?
    By [email protected] in forum Excel General
    Replies: 2
    Last Post: 06-27-2005, 01:05 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