| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column conversion
How can I convert a column from alpha to numeric?
i.e. convert BZ to 78 Is there a simple conversion or do I have to write my own? I have data in cols A and B and BZ-CF. How would I say : Columns("B+1:BZ-1").Select Selection.Delete Shift:=xlToLeft |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CSV Column Conversion | Excel Worksheet Functions | |||
| Row to column conversion | Excel Discussion (Misc queries) | |||
| Perpelexing Row to Column conversion | Excel Discussion (Misc queries) | |||
| Excel Column and row conversion | Excel Discussion (Misc queries) | |||
| How to use a conversion function in a whole column | Excel Programming | |||
![Charlie[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
