This may be a very simple question, but I'd like Column A to be a sequence of numbers and letters. For example, A0001, A0002, A0003....A0010...etc. Is there a formula that will do this? Thanks for your help.
This may be a very simple question, but I'd like Column A to be a sequence of numbers and letters. For example, A0001, A0002, A0003....A0010...etc. Is there a formula that will do this? Thanks for your help.
One way
VBA Noob="A"&TEXT(ROW(A1),"0000")
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks