+ Reply to Thread
Results 1 to 8 of 8

Replace Character and Convert to Proper Case

  1. 03-15-2018, 08:06 AM #1
    Barieq
    Barieq is offline
    Forum Contributor
    Join Date
    11-12-2012
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2010, 2013, 2016, Office 365
    Posts
    507

    Replace Character and Convert to Proper Case

    Hi,

    Can anyone help me to solve to replace the old text with new. Below is the text for example. I have attached the file for more information.
    Old Text- 749100- -Vehicle Running-25115:FUDDRUCKERS ANDALUS-2, CUTTK
    Replace with - 749100- -Vehicle Running | 25115-Fuddruckers Andalus-2, Cuttk

    Regards,
    Barieq
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-15-2018, 08:16 AM #2
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,571

    Re: Replace Character and Convert to Proper Case

    B2:

    =PROPER(SUBSTITUTE(SUBSTITUTE(A2,"-"," | ",3),":","-"))
    and copy down.
    Reply With QuoteRegister To Reply
  3. 03-15-2018, 08:21 AM #3
    Barieq
    Barieq is offline
    Forum Contributor
    Join Date
    11-12-2012
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2010, 2013, 2016, Office 365
    Posts
    507

    Re: Replace Character and Convert to Proper Case

    It is possible in macro and also the proper case should start only after this text 25115:FUDDRUCKERS ANDALUS-2, CUTTK
    Reply With QuoteRegister To Reply
  4. 03-15-2018, 08:38 AM #4
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,571

    Re: Replace Character and Convert to Proper Case 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 03-18-2018, 06:01 AM #5
    Barieq
    Barieq is offline
    Forum Contributor
    Join Date
    11-12-2012
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2010, 2013, 2016, Office 365
    Posts
    507

    Re: Replace Character and Convert to Proper Case

    Dear Jindon,

    Is it possible to replace the text in Cloumn A itself, instead of using the formula in Column B
    Reply With QuoteRegister To Reply
  6. 03-18-2018, 06:26 AM #6
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,571

    Re: Replace Character and Convert to Proper Case

    Change to
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 03-18-2018, 07:20 AM #7
    Barieq
    Barieq is offline
    Forum Contributor
    Join Date
    11-12-2012
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2010, 2013, 2016, Office 365
    Posts
    507

    Re: Replace Character and Convert to Proper Case

    Excellent, Thanks Jindon.
    Reply With QuoteRegister To Reply
  8. 03-18-2018, 07:22 AM #8
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,397

    Re: Replace Character and Convert to Proper Case

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Replace Character and Convert to Proper Case
    By Barieq in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-15-2018, 10:03 AM
  2. [SOLVED] Need the proper syntax to use Case/Select Case in vba properly.
    By rbion in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-16-2013, 02:34 PM
  3. Excel 2007 : Change Address Database from upper case to proper case
    By FC Morris in forum Excel General
    Replies: 3
    Last Post: 10-30-2009, 04:00 PM
  4. Proper Case not doing letter after a character
    By dugong in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2008, 12:34 PM
  5. Using VBA to convert text to proper case
    By Darlo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2007, 05:59 PM
  6. excel'03 how to convert a column from upper case to proper case
    By sharie palmer in forum Excel General
    Replies: 1
    Last Post: 01-30-2006, 07:55 PM
  7. Excel: How do I change all upper case ss to proper case?
    By Moosieb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-12-2006, 08:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1