formula help

  • Thread starter Thread starter scrabtree23
  • Start date Start date
S

scrabtree23

In "column A" in "Cells 1 and 2" I have the following
data: A1234 and B4321 respectively. I need to have a
formula to drag down "column B" that would convert the
letters to numbers as follows: A1234 would become 11234
and B4321 would become 24321. Help?
 
=((CODE(LEFT(A1))-64) & RIGHT(A1,LEN(A1)-1))*1

then drag fill down the column.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting Values and Trimming Text 5
Evalulate previous cell 6
How to create this form or report 3
multiple lines 3
A data validation question 1
Connects query 6
custom sort by vba 4
To list down all SN (Serial Number) 6

Back
Top