| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Removing select text from a cell
I have a cell formatted for Text with the following information;
006-0527-5475 I want to remove just the huphens so it looks like this; 00605275475 Does anyone have the formula or process I can use? I have about 3000+ cells I need to modify this way. Thank you. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Removing select text from a cell
Hi Tim
Go to EditFindtype - than Replace put nothing. Press find All Replace All. HTH John "Tim Millar" wrote in message ... I have a cell formatted for Text with the following information; 006-0527-5475 I want to remove just the huphens so it looks like this; 00605275475 Does anyone have the formula or process I can use? I have about 3000+ cells I need to modify this way. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| removing text characters from a cell | Excel Worksheet Functions | |||
| Removing text from a cell with text and numbers | Excel Discussion (Misc queries) | |||
| Removing select informaion from cells | Excel Discussion (Misc queries) | |||
| Removing Numbers from a Cell that also has text. | Excel Discussion (Misc queries) | |||
| removing part of text string to another cell | Excel Discussion (Misc queries) | |||
Linear Mode
