Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The Excel cell contains text with a "-" minus sign embedded in it (e.g. a
phone number). Q: Is there a Hotkey that will 1) "Find" the minus sign, and 2) Place the cursor right on top of that character? Excel's "Find-and-Replace" doesnt work within the cell. The macro I'm writing should massage the text in the following way: 1- (F2) Edit the text. 2- (How?) Find the minus sign, and position the cursor on top of it. 3- (Shft-Ctrl-End) Highlight all text from the minus sign to the end of the cell. 4- (Ctrl-X) Cut the text. 5- (Tab, Ctrl-V) Move one cell to the right and paste the string. Simple... I wish. Thxs - D.D. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel2007 hotkey | New Users to Excel | |||
hotkey in usrform | Excel Programming | |||
set cursor position to that last character | Excel Programming | |||
Custom Hotkey Strategy | Excel Programming | |||
Alt + Enter hotkey - what does this do? | Excel Programming |