+ Reply to Thread
Results 1 to 4 of 4

Change letters to Shapes using a formula?

  1. #1
    Registered User
    Join Date
    12-09-2014
    Location
    Chicago, Illinois
    MS-Off Ver
    Microsoft Office 2010
    Posts
    3

    Change letters to Shapes using a formula?

    Hello! The company I work for uses letters to show significantly higher or lower data in some parts of our work, and alternately uses arrows (up and down arrows) in other parts. Is there a way to use a formula to automatically convert a letter or multiple letters to one or more arrows within a cell?

    Any help is appreciated. Thank you!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Change letters to Shapes using a formula?

    Could you do it by means of a VLOOKUP??

    You could hide the column containing the source letter and hide the lookup arrasy.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    12-09-2014
    Location
    Chicago, Illinois
    MS-Off Ver
    Microsoft Office 2010
    Posts
    3

    Very confused! Is there a way to change a letter to a shape in the same cell?

    I guess now I am to a different point of confusion and am unsure if there is a way using macros to do this. I want a formula to replace a letter, in the same cell. An IF formula works but it still ends up in the cell next to the letter, and the letter is still there. I want an up or down arrow to REPLACE the letters. The other thing I am confused about is that the arrows may not always need to be in the same place as the letters, but I still want the letters deleted... This is for significance testing and, for example, if we have 600 A, 398 and 200, where 600 is the "total" column and we want to show 200 as being significantly lower using a 90% significance level; we would want the A in the total column to erase and a down arrow to show in column C next to 200.

    Any thoughts? Thank you for the feedback!

  4. #4
    Registered User
    Join Date
    12-09-2014
    Location
    Chicago, Illinois
    MS-Off Ver
    Microsoft Office 2010
    Posts
    3

    Re: Very confused! Is there a way to change a letter to a shape in the same cell?

    Ok, so for example this workbook. If you look at sheet 1, I need a formula to replace both of the letter B's with upward arrows that can be filled with a color. Not just a line arrow, and I don't want to manually have to do it to each one. I guess this is a good place to start.
    Attached Files Attached Files

+ 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. Looping through Shapes to change transparency
    By JoeSkittles in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-24-2013, 11:09 AM
  2. [SOLVED] Change color of text for a group of shapes
    By emiliekatherine in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2012, 08:43 AM
  3. How To Move Shapes From Another Shapes? (floating shapes)
    By MarcLev in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2009, 04:04 PM
  4. [SOLVED] How do I keep letters the same and change the # for drag formula
    By ASST in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-22-2006, 09:30 PM
  5. [SOLVED] Change order of Shapes with a click
    By John Michl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-21-2005, 06:00 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1