Results 1 to 11 of 11

How to remove dot(s) .. or ... in front of text string, not in a middle

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007, MS 365 (Windows 10 Pro 64-bit)
    Posts
    811

    How to remove dot(s) .. or ... in front of text string, not in a middle

    Hello All,
    I'm loking for code to remove two dot or three dot in front of text string but not single dot in middle. If I use replace then it remove all dot.

    Exp:

    ..123 => 123
    ..abc => abc
    ...456 => 456
    ...def => def
    123.456 => 123.456
    ...123.456 => 123.456
    ..abc.123 => abc.123
    456789 => 456789

    Regards,
    tt3
    Last edited by tuongtu3; 09-23-2013 at 05:45 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Remove middle name for end of a name string
    By maacmaac in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-30-2022, 04:44 PM
  2. how to remove a character from the middle of text on all cells
    By webuxer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2013, 06:01 PM
  3. [SOLVED] if formula looking at value in middle of text string
    By SAsplin in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-25-2013, 06:57 AM
  4. remove non-existent space in front of text in excel
    By ewong in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-27-2012, 12:30 PM
  5. [SOLVED] pulling text from the middle of a string
    By DRFILL in forum Excel General
    Replies: 3
    Last Post: 09-21-2012, 11:35 AM

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