formula with letters and numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excell 2000 or Excell 2003 can a formula be set up to use letters and numbers
like V2 to record in column for v the number 2 if the input is v4 the number
would be 4 and in the same cell the combination of T3 could be entered and in
the column for t would record 3.
 
Try this:

For
A1 containing a column reference followed by a numeric value
Example: AF205

B1:
=IF(LEFT($A1,MIN(SEARCH({"-",0,1,2,3,4,5,6,7,8,9},$A1&"-0123456789"))-1)&ROW()=ADDRESS(ROW(),COLUMN(),4),MID($A1,MIN(SEARCH({"-",0,1,2,3,4,5,6,7,8,9},$A1&"-0123456789")),99)*1,"")

Copy that formula across as far as needed.

Note_1: that formula also accommodates negative numbers:
AV-50.25 would enter -50.25 in column AV.

Note_2: Since text wrap will impact the display, there are NO spaces in that
formula.

Comment: Whatever your purpose is for wanting this....I suspect there must
be a better way.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Back
Top