| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace many asterisk characters, '*' in Excel
How do I replace a lot of asterisks, '*', in Excel XP. They are appended to
numeric data values, changing the values to text values so I can't run fomulae on the original values. Trying "Replace *, <null " on the spreadsheet deletes all data. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replace many asterisk characters, '*' in Excel
Tilda can help you
Replace ~* with nothing -- Gary's Student "-G." wrote: How do I replace a lot of asterisks, '*', in Excel XP. They are appended to numeric data values, changing the values to text values so I can't run fomulae on the original values. Trying "Replace *, <null " on the spreadsheet deletes all data. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replace many asterisk characters, '*' in Excel
Use the following formula:
=VALUE(SUBSTITUTE(A1,"*","")) The value function converts the resulting string to numeric. Gary "-G." wrote: How do I replace a lot of asterisks, '*', in Excel XP. They are appended to numeric data values, changing the values to text values so I can't run fomulae on the original values. Trying "Replace *, <null " on the spreadsheet deletes all data. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replace many asterisk characters, '*' in Excel
Replace
~* With < leave Blank Back up before you try!!!!! "-G." wrote: How do I replace a lot of asterisks, '*', in Excel XP. They are appended to numeric data values, changing the values to text values so I can't run fomulae on the original values. Trying "Replace *, <null " on the spreadsheet deletes all data. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replace many asterisk characters, '*' in Excel
Sorry for the BLANk fired;
The ~* << is what you want to replace with nothing "-G." wrote: How do I replace a lot of asterisks, '*', in Excel XP. They are appended to numeric data values, changing the values to text values so I can't run fomulae on the original values. Trying "Replace *, <null " on the spreadsheet deletes all data. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CSV file containing german characters imported into Excel | Excel Discussion (Misc queries) | |||
| Find and replace should work in Excel text boxes | Excel Discussion (Misc queries) | |||
| How can I replace 2 of 5 characters within an cell in MS Excel? | Excel Worksheet Functions | |||
| macro to Find Replace in Excel | Excel Discussion (Misc queries) | |||
| How do I search for an asterisk in an Excel file--it thinks the a. | Excel Discussion (Misc queries) | |||
Linear Mode
