+ Reply to Thread
Results 1 to 3 of 3

formula to convert specific word alphabet in a word to upper case only

  1. 04-18-2020, 12:48 PM #1
    JEAN1972
    JEAN1972 is offline
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    formula to convert specific word alphabet in a word to upper case only

    I have description lower case in column A except the first word is upper case .

    My goal to convert a specific word u to U capital

    Jus citron jaune u

    results should be in column B

    Jus citron jaune U

    I have tried SUBSTITUTE but all letter with u get all get U capitalize .
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-18-2020, 12:53 PM #2
    AliGW
    AliGW is online now
    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. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,874

    Re: formula to convert specific word alphabet in a word to upper case only

    Did you try this?

    =SUBSTITUTE(A1," u "," U ")
    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
  3. 04-18-2020, 01:19 PM #3
    JEAN1972
    JEAN1972 is offline
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    Re: formula to convert specific word alphabet in a word to upper case only

    Perfect

    Thank you
    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. Capital each word excluding “and” in the post code column all letters in upper case
    By wykoems in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-25-2018, 09:07 AM
  2. [SOLVED] Help needed with a formula to convert upper-case words only to lower-case
    By holmwood in forum Excel General
    Replies: 7
    Last Post: 04-18-2014, 04:11 PM
  3. [SOLVED] Convert 1st letter of word to Upper Case and rest to lower case
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-23-2013, 11:44 AM
  4. How to make Upper Case in every word in a Cell
    By karinos57 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-12-2009, 10:18 PM
  5. [SOLVED] 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
  6. [SOLVED] Convert lower case charecters to upper case
    By Dinesh in forum Excel General
    Replies: 3
    Last Post: 09-10-2005, 08:05 AM
  7. How do I convert all upper case excel sheet into upper and lower .
    By DebDay in forum Excel General
    Replies: 1
    Last Post: 03-09-2005, 05:06 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