Thread: Auto Convert Text. I.E. Abbreviation to Complete Word (Hard to describe)
View Single Post
 
Old 01-23-2017, 11:24 PM
Chrisiztopher Chrisiztopher is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Jan 2017
Posts: 1
Chrisiztopher is on a distinguished road
Default 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.
Reply With Quote