Line adding /Change

[larrywcc]

753801 - Automobile Repairing & Service
I have the above in two fields A and B

Field A is Blank and Field B has the above in it.

There is 65535 lines of descriptions.

I must have field A-1 start at 1 and A-2 at 2 etc... all the way to A-65535. I know this could be simple but I can't remember how.

Thanks for any HELP!

Larry

[Mark@Work]

753801 - Automobile Repairing & Service
I have the above in two fields A and B

Field A is Blank and Field B has the above in it.

There is 65535 lines of descriptions.

I must have field A-1 start at 1 and A-2 at 2 etc... all the way to A-65535. I know this could be simple but I can't remember how.

Thanks for any HELP!

Larry

Just to clarify:

Column A is blank ;
Column B contains some text (753801 - Automobile Repairing & Service).

You want to put the numbers 1-65535 in column 1.

Enter 1 in A1, 2 in B2.
Select A1:A2 then drag the bottom right corner of the box down...

Is that what you want, or have I misunderstood?

Mark.

[larrywcc]

Mark,

Thanks, That worked !!! Has been long time that I used that!!!


Again Thanks,

Larry