formula with letters and numbers
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. |
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. |
All times are GMT +1. The time now is 04:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com