+ Reply to Thread
Results 1 to 3 of 3

Replace V with ✔️

  1. #1
    Forum Contributor
    Join Date
    05-28-2010
    Location
    Antwerp, Belgium
    MS-Off Ver
    Office 365
    Posts
    168

    Replace V with ✔️

    I would like to achieve the following: when I am typing 'V' in a cell it will replace it with the emoji ✔️
    How can I achieve it through formatting?

    Thanks

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,518

    Re: Replace V with ✔️

    Hi whatever,

    How about using a Substitute formula like the attached?

    Substitute v with check.xlsx

    If the attached is good enough a substitute then some VBA might be the final answer.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,502

    Re: Replace V with ✔️

    To use auto correct
    1. copy those two symbols
    2. Open MS Word, click the Office button
    3. Select Word Options
    4. Proofing, Autocorrect options
    5. In the Replace box, type v/
    6. Paste the copied characters in the With box.
    * ensure that the Replace text as you type option is checked. OK. Close Word. In Excel, type v/
    Ben Van Johnson

+ 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. Macro: Search and replace: Replace using a cell reference
    By kalyan46 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2019, 07:11 PM
  2. Replies: 1
    Last Post: 02-27-2018, 11:22 AM
  3. REPLACE function help replace two separate texts Ctrl H
    By Uldis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-23-2015, 10:51 AM
  4. [SOLVED] find and replace to not replace characters found as wildcards
    By sabutler4 in forum Excel General
    Replies: 4
    Last Post: 07-03-2013, 06:48 PM
  5. Multiple Find and Replace to replace a list of strings
    By WalterP34 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-11-2011, 07:41 PM
  6. [SOLVED] find and replace - replace data in rows to separated by commas
    By msdker in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2006, 08:10 PM
  7. How can I use replace(alt+H) for mutiple items needing replace
    By Gery in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 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