| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I remove a text character from an excel cell?
I have a lot of data that is in the format 123-4567. I need to convert this
to be 1234567. Does someone know how to do this with a formula? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I remove a text character from an excel cell?
editreplace
-- Don Guillett SalesAid Software "Mark" wrote in message ... I have a lot of data that is in the format 123-4567. I need to convert this to be 1234567. Does someone know how to do this with a formula? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I remove a text character from an excel cell?
Hi Mark,
=substitute(a1,"-","") HTH Cheers Carim |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I remove a text character from an excel cell?
Do you want a formula?
You could get rid of the "-" using editreplace Gord Dibben MS Excel MVP On Fri, 13 Oct 2006 05:35:02 -0700, Mark wrote: I have a lot of data that is in the format 123-4567. I need to convert this to be 1234567. Does someone know how to do this with a formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| wrap text function causes data to disappear in cell (visually only | Excel Discussion (Misc queries) | |||
| The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel | Excel Discussion (Misc queries) | |||
| How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
| Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
| Why doesn't text wrap in a cell in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
