| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy across row alpha - not numeric.
I found this to copy alpha down, but need help to do this across the row.
=LEFT(ADDRESS(1,ROW(B1),4,1),FIND("1",ADDRESS(1,RO W(B1),4,1))-1) Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy across row alpha - not numeric.
=LEFT(ADDRESS(1,COLUMN(A1),4,1),FIND("1",ADDRESS(1 ,COLUMN(A1),4,1))-1)
"laralea" skrev: I found this to copy alpha down, but need help to do this across the row. =LEFT(ADDRESS(1,ROW(B1),4,1),FIND("1",ADDRESS(1,RO W(B1),4,1))-1) Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy across row alpha - not numeric.
=CHAR(64+COLUMN(A1))
Will that do? Mike "laralea" wrote: I found this to copy alpha down, but need help to do this across the row. =LEFT(ADDRESS(1,ROW(B1),4,1),FIND("1",ADDRESS(1,RO W(B1),4,1))-1) Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy across row alpha - not numeric.
Hi Mike
That will work absolutely fine up to column Z, which may well be sufficient for the OP. However, you have to add some more conditions to take it on to 256 columns, and another if you are operating on XL2007 to cope with 1024 columns. -- Regards Roger Govier "Mike H" wrote in message ... =CHAR(64+COLUMN(A1)) Will that do? Mike "laralea" wrote: I found this to copy alpha down, but need help to do this across the row. =LEFT(ADDRESS(1,ROW(B1),4,1),FIND("1",ADDRESS(1,RO W(B1),4,1))-1) Thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy across row alpha - not numeric.
Hi
Try =SUBSTITUTE(ADDRESS(1,COLUMN(A1),4),1,"") -- Regards Roger Govier "laralea" wrote in message ... I found this to copy alpha down, but need help to do this across the row. =LEFT(ADDRESS(1,ROW(B1),4,1),FIND("1",ADDRESS(1,RO W(B1),4,1))-1) Thanks! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy across row alpha - not numeric.
you guys rock! thanks for the help!!
"laralea" wrote: I found this to copy alpha down, but need help to do this across the row. =LEFT(ADDRESS(1,ROW(B1),4,1),FIND("1",ADDRESS(1,RO W(B1),4,1))-1) Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alpha Numeric tab not showing only numeric. | Excel Worksheet Functions | |||
| only extract numeric value from alpha numeric cell | Excel Discussion (Misc queries) | |||
| +1, Alpha *and* Numeric | Excel Worksheet Functions | |||
| The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) | |||
| Convert Alpha to Numeric | Excel Discussion (Misc queries) | |||
Hybrid Mode
