Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA MID Function
Hi
why do you want to use a VBA macro. You could use the worksheet formula =MID(A1,5,4) in B1 and copy this down But maybe I'm missing something in your requirements -- Regards Frank Kabel Frankfurt, Germany Michael E. wrote: Hi, I do have strings of characters in a column of cells. Each cell has exact the same number of characters (11). Like this: Cells from A1 to A4 tva/1,23/bn bnc/2,24/vb gzc/3,12/jb hzf/1,56/hj I only need the characters at position 5,6,7,8: 1,23 2,24 3,12 1,56 I would like to do the task with a vba-macro that selects cells A1-A4 and then shows only the 4 charakters. I think the vba MID-Function Mid (string, start, length) would be the right tool. But I donĀ“t know how to write the makro. Can anyone help? Thanks a lot Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA MID Function
Hi Frank
I need a vba-macro to extract the 4 characters because this macro should later be intergrated in a different macro Regard Michhael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
Adding a custom function to the default excel function list | Excel Programming | |||
When I Import an Access Table With an Excel Function in a Cell it Displays as Text not as a Function in Excel | Excel Programming | |||
Excel - saving result of a function without showing the function | Excel Programming |