Assign Number to row

Hi guys,

I have a list of numbers such as:
A01
A23
A53
A64
A74
A128
B01... the goes on too approximatly D128

and i wanted to know if there is a way to assign the value to the row?
For example:
A23 in column A row 23
A53 in column A row 53

is there any method that achieves this?

Kind Regards,

Tai

Try this:

="A"&ROW()

If you want the "A" and the "23" to both be automatic, try this:

=ADDRESS(ROW(),COLUMN(),4)

=MID("ABCDEFGHIJKLMNOPQRSTUVWXYZ",COLUMN(A1),1)&ROW(A1)

copy down and across for up to 26 columns if needed

Hey,

Thanks for the reply,

I ment from the list i want to move the values automatically to that sepecific cell. the list of numbers is in a random order, and i want the values to be in the right column and row.

A01
A23
A53 < This is the list in random order
A64
A74
A128
B01...

And i want it to be moved automatically in the correct row and column eg:

A64 must move to :

column A
Row
62
63
64 A64

and show that value

sorry guys should have made it clear at the begining, i do apologise!

Regards,

Tai

Matt, please don't ask questions in someone else's thread -- start your own.

If you've not read the forum rules, now would be a good time to do so.

Thanks, Matt.

VBA has excellent support for regular expressions. We can talk about it in your new thread.