PDA

View Full Version : Solved: counting with text help



jimayers
11-14-2010, 12:59 AM
Hi - I need to get Column A to count from one cell to the next. I have barcodes that need to be entered consecutively with text. For example, A1 = MA001 and A2 = MA002 and so on.
I could use some help writing the function or making a macro for this.

any help is appreciated - Jim Ayers

Bob Phillips
11-14-2010, 02:21 AM
Your request is not clear. You say youwant to count from one cell t the next, which is easily achieved with =COUNTA(A:A)
then you say you want a mcro to enter them consecutively.

What exactly do you want?

Tinbendr
11-14-2010, 05:52 AM
For example, A1 = MA001 and A2 = MA002 and so on.You can use the cell format and formula to accomplish this. Highlight column, right click-Format Cells-Custom-Enter "MA"000. In A1 enter 1. In A2 enter =A1 + 1 and copy down.

jimayers
11-14-2010, 12:38 PM
Thanks for your reply. I got the function ="MA"&TEXT(ROW(), "000") to work.

Thanks again - Jim