Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove any letter from a referenced cell
Hi Mike,
This sounds very promising, but I only have "user form", "module" and "class module" in the "insert" sub-menu available when I right-click on 'this workbook'... Which one should I choose or what should I do to get to where you think I should be??? Thanks. "Mike H" wrote: Hi, Alt + f11 to open VB editor. Right click 'this workbook' insert function and paste this in Function extractthings(rng As range) Set RegExp = CreateObject("vbscript.RegExp") With RegExp .Global = True .Pattern = "[\d\-\&]" End With Outstring = "" Set Collection = RegExp.Execute(rng) For Each RegMatch In Collection Outstring = Outstring & RegMatch extractthings = Outstring Next End Function then in b1 insert the formula =extractthings(a1) Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to remove a letter from one cell to another | Excel Discussion (Misc queries) | |||
remove first letter | Excel Worksheet Functions | |||
The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
See where a cell is referenced | New Users to Excel | |||
How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) |