Results 1 to 3 of 3

Ignore dash sign while concatenate

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Ignore dash sign while concatenate

    Hello friends,
    I don't want the dash sign in my address. I want to modify the case 7 which will ignore dash sign while concatenate.

    Please help to solve my problem.

    Mukesh
    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. [SOLVED] code to insert dash sign
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 07-06-2013, 11:01 PM
  2. I see a dash, Excel sees a minus sign.
    By vishorizons in forum Excel General
    Replies: 3
    Last Post: 11-09-2009, 11:02 AM
  3. Concatenate and ignore blanks
    By nujwaan in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 09-24-2009, 11:23 AM
  4. Concatenate and ignore blanks
    By nujwaan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-22-2009, 04:25 AM
  5. Concatenate formula not taking decimal places/currency sign
    By woodsonline in forum Excel General
    Replies: 4
    Last Post: 05-27-2009, 03:34 AM

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