| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert "/" into cells that contain data, using a macro
I need to insert a "/" symbol into multiple cells which already contain data.
For example: the cell already contains 2 letters and 10 digits and I need to insert the / symbol after the 2 letters and then again after the next 5 digits, so the data changes from aa########## to aa/#####/#####. All the cells are in one column so it's simple to get a macro to select the column, but I don't know how to insert characters. Any ideas? I'm using Excel 2007. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I "insert copied cells"? used to be "alt i e" still work | Excel Worksheet Functions | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
| Insert 19 cells "Shift to the right" if cell contains "-" | Excel Programming | |||
| Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming | |||
Threaded Mode
