| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Strip out the ' at the beginning of cell contents
Hi All the entries to my cells in column A seem to have a ' symbol at the start of them. A formula I'm using in column B is failing because of this. When I manually remove the ' from the formula box , my formula works. Does anyone know how to strip out the leading ' from all the cells , and leave all the real data intact? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Strip out the ' at the beginning of cell contents
One way,
Put a zero in a cell and copy it. select your data with apostrophes and then Edit|Pastespecial Select add Click OK Mike "Colin Hayes" wrote: Hi All the entries to my cells in column A seem to have a ' symbol at the start of them. A formula I'm using in column B is failing because of this. When I manually remove the ' from the formula box , my formula works. Does anyone know how to strip out the leading ' from all the cells , and leave all the real data intact? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Strip out the ' at the beginning of cell contents
In article , Mike H
writes One way, Put a zero in a cell and copy it. select your data with apostrophes and then Edit|Pastespecial Select add Click OK Mike Hi Rick and Mike Thanks for those solutions - both worked really well. I'm grateful. The 'Add 0' solution worked on all entries , and puts a zero in blank cells. I cleared these out using a simple search and replace. The text to column solution works on the cells containing exclusively numbers , but not on those containing some letters - of which there were a few. I wonder if there is a similar route which would work on all entries. Anyway , job done - thanks again. ^_^ "Colin Hayes" wrote: Hi All the entries to my cells in column A seem to have a ' symbol at the start of them. A formula I'm using in column B is failing because of this. When I manually remove the ' from the formula box , my formula works. Does anyone know how to strip out the leading ' from all the cells , and leave all the real data intact? Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Strip out the ' at the beginning of cell contents
Are these entries all numbers? If so, select them, and then click on the
Data/Text To Column item in Excel's menu bar, select Delimited and then click the Finish button. Rick "Colin Hayes" wrote in message ... Hi All the entries to my cells in column A seem to have a ' symbol at the start of them. A formula I'm using in column B is failing because of this. When I manually remove the ' from the formula box , my formula works. Does anyone know how to strip out the leading ' from all the cells , and leave all the real data intact? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert character at beginning of cell without changing contents | Excel Discussion (Misc queries) | |||
| Strip Values From Cells To Create New Cell Value | Excel Discussion (Misc queries) | |||
| Strip leading spaces from cell | Excel Worksheet Functions | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
| How can I strip a new line /nl in a cell in Excel globally | Excel Worksheet Functions | |||
Hybrid Mode
