Possible to change text in real time in Excel 2010?

Post » Thu Feb 14, 2013 2:16 pm

I have what seems to be a fairly easy question for Excel, but I can't seem to find what I need. Maybe I'm not wording it correctly on Google. Anyways, here we go:

I am comparing some information and entering data into cells (obviously). What I'm entering are category names and numbers for products. They have to be entered by hand in the format of "Parent Category|Category Number|Category Name". It's tedious and I would like to be able to speed it up.

What I'm hoping for is a macro or VB code that allows me to enter just the category number into the cell, realize what I wrote, and change it to the proper format with the correct names. For example, I would enter 100 and hit Enter, and it would automatically change that cell to "Toys|100|Puzzles". I understand I would have to enter in all of the different categories into the formula or whatever by hand, but doing it once for each is better than having to do it repeatedly for all of them.

Any ideas?
User avatar
Saul C
 
Posts: 3405
Joined: Wed Oct 17, 2007 12:41 pm

Return to Othor Games