| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace characters from cell values
Hi all
I would like to remove the number and dash from the cell values as follows: 1 - Apples 2 - Oranges 3 - Bananas etc I can't use the MID function as is as the digit prefix can be more than 1 character. I was thinking of the REPLACE function but it doesn't seem to accept a wildcard character (eg "* - "). Any ideas appreciated. Paul Martin Melbourne, Australia |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace Cell Values | Excel Discussion (Misc queries) | |||
| Find and replace specific characters within a cell based on positi | Excel Discussion (Misc queries) | |||
| How do you find and replace tab characters in a cell in Excel? | Excel Discussion (Misc queries) | |||
| How can I replace 2 of 5 characters within an cell in MS Excel? | Excel Worksheet Functions | |||
| Append Text to Cell Values Using Replace | Excel Discussion (Misc queries) | |||
Threaded Mode
