Hotkey that finds a character, then positions cursor on it?
D.D. - Also consider using a formula in the cell to the right of the phone
number in A5:
=RIGHT(A5,LEN(A5)-SEARCH("-",A5,1)+1) <<<includes the minus sign
=RIGHT(A5,LEN(A5)-SEARCH("-",A5,1)) <<<excludes the minus sign
--
Jay
"D.D." wrote:
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.
|