Thread: [Solved] Data entry asistance needed
View Single Post
 
Old 09-03-2014, 04:00 PM
fireman0174 fireman0174 is offline Mac OS X Microsoft Office 2008 for Mac
Novice
 
Join Date: Aug 2010
Posts: 8
fireman0174 is on a distinguished road
Default Data entry asistance needed

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!!
Reply With Quote