| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find and delete a character from multiple columns
I have a Excel spreadsheet that is an export of data from Microsoft CRM
3.0 In a number field that should be a dollar amount CRM is exporting the $ which is being broght into Excel as Number stored as Text, I would like to write either a macro of VBA script that would either convert the cell to currency or delete the $ for each sell that the $ is in, in the spreadsheet. Does anyone know how to do that. Any help would be greatly appreciated. Thanks in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find and delete a character from multiple columns
How about doing a find and replace (Ctrl + H)? Replace the $ with nothing.
When this is done Excel should do an implicit conversion of the text to number... If you want you can record a macro while doing this. -- HTH... Jim Thomlinson "scrocker" wrote: I have a Excel spreadsheet that is an export of data from Microsoft CRM 3.0 In a number field that should be a dollar amount CRM is exporting the $ which is being broght into Excel as Number stored as Text, I would like to write either a macro of VBA script that would either convert the cell to currency or delete the $ for each sell that the $ is in, in the spreadsheet. Does anyone know how to do that. Any help would be greatly appreciated. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use of multiple-character delimiters under Text To Columns | Excel Discussion (Misc queries) | |||
| How to remove (delete) the first Character in all of the columns | Excel Discussion (Misc queries) | |||
| Find & Delete columns to the left stopping at column B | Excel Programming | |||
| Find & Delete columns to the left stopping at column B | Excel Programming | |||
| find and delete duplicate entries in two columns or find and prin. | Excel Programming | |||
Linear Mode
