I’m trying to input some data into an Excel 2010/2011 sheet. One data field (cell) is beyond my ability and so I’m hopeful that someone can assist me.

Here’s an example of the data that will get entered as text:

BC10201412345

The BC102014 is a “constant”. What I want to do, is enter, as in this example, “12345” (no quotes to be inputted).

So I want to type 12345 and have it entered into the cell as BC10201412345. Hope that makes sense.



I think Visual Basic is the answer, but I don’t know to do it. Or perhaps there’s a different way.

I’m all ears!

In advance, thanks!!