formula with letters and numbers
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(SEA RCH({"-",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
"Bigdaddy0242" wrote:
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.
|