+ Reply to Thread
Results 1 to 3 of 3

Wild Card search with space ??

Hybrid View

  1. #1
    Registered User
    Join Date
    09-10-2008
    Location
    FL
    Posts
    4

    Wild Card search with space ??

    I want to do a global replace of .com .net .org etc.... using .???
    The issue i have is how to include the space at the end.

    eg.

    change '.com ' to '.com;'
    '.net ' to '.net;'

    I have tried single and double quotes but it does not work!
    If i want to change .??? to .???;
    The downside of using .??? is if i have an email of :
    bob.slocom@gmail.com it gets change to:

    bob.???;@gmail.???;

    All i want to do is add a semi colon to the end of all emails.
    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626
    I don't think there is a method to replace them together,
    how many different domin names do you have?
    Why not replace them one by one
    I need your support to add reputations if my solution works.


  3. #3
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Quote Originally Posted by oldtech View Post
    I want to do a global replace of .com .net .org etc.... using .???
    The issue i have is how to include the space at the end.

    eg.

    change '.com ' to '.com;'
    '.net ' to '.net;'

    I have tried single and double quotes but it does not work!
    If i want to change .??? to .???;
    The downside of using .??? is if i have an email of :
    bob.slocom@gmail.com it gets change to:

    bob.???;@gmail.???;

    All i want to do is add a semi colon to the end of all emails.
    Thanks
    If these domains are listed in a column or two, you can use a helper column that "adds the semicolon on the original text" with a simple formula like =A1&";"

    then you can copy|Paste Special >> Values over the original and delete the helper.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

+ 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. Update from one workbook to another
    By dvspriest in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-08-2008, 09:50 PM
  2. make number formatting real, not just format
    By oompa_l in forum Excel General
    Replies: 7
    Last Post: 06-16-2008, 07:15 PM
  3. Writing a program with changing variables. . .
    By salex in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2007, 03:32 PM
  4. Search Function
    By jonn in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-03-2007, 03:26 AM
  5. use of wild card in file name.
    By avveerkar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2007, 09:27 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