|
|
#1
01-23-2017, 11:24 PM
|
|||
|
|||
Auto Convert Text. I.E. Abbreviation to Complete Word (Hard to describe)
Ive got a sheet that i use to create templates for a video game.
You can create a character in the game and with the template ive created Im able to make a template so that others can use that character too. It has a lot to do with color formulas. For example SHIRT = blk (for Black) PANTS = wht (for White) when the template is complete ill have several blk and wht cells.  Id like to auto convert to this: SHIRT = 1- -2- -3 -4 PANTS= 16- -20- -24- -28  Currently I just hit the replace function and replace the blk with the color formula which is fine but I think this could save me a lot of time. NOTE: I use 1 Sheet for the data entry and the 2nd sheet to return the results, the CELL that shows the results should be converted NOT the cell in the data entry sheet. Thanks in advance. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Macro Needed To Convert Text in Word to Plain Text and Back to Word
|
rsrasc | Word VBA | 5 | 12-18-2015 07:13 AM |
| The most appropriate way to describe XML data in word. | Somyata | Word | 2 | 10-09-2014 11:13 PM |
|
Auto-complete and typing in drop down lists
|
bcemail | Word | 1 | 03-27-2014 05:45 PM |
| Word Question - not sure how to describe | CrzyIcE | Word | 1 | 04-05-2010 04:13 AM |
|
In Outlook 2003 auto complete won't work
|
Meenie | Outlook | 2 | 06-11-2009 08:24 AM |
Windows 7 64bit 
Office 2010 64bit
Linear Mode
