| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding and moving hypens from end to beginning of cell
Hi,
I want to be able to find and change all ###- entries into -### in a worksheet (or a selected range). i.e. Move the hyphen from the end of the cell to the beginning (negative number) and remove any spaces that may be at the beginning or end of the cell. Thanks for any help. Example 123-(space) change to -123 (space)234- -234 12-%(space) -12% (space)-(space) leave as is or remove spaces |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding and then moving entire row to new sheet based on cell value | Excel Discussion (Misc queries) | |||
| Finding average beginning at first cell in row 0? | Excel Discussion (Misc queries) | |||
| how can I remove hypens from a field | Excel Discussion (Misc queries) | |||
| finding blank cell and moving specific data into it | Excel Worksheet Functions | |||
| Automatically moving a chart range at the beginning of the next month | Excel Programming | |||
![Amy[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
