| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove a part of a cell
I have a long series of numbers which contains the asterisk symbol (*). How
can I remove this symbol from these many numbers? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove a part of a cell
Click Edit, Replace. leave "replace with" blank
BTR wrote: I have a long series of numbers which contains the asterisk symbol (*). How can I remove this symbol from these many numbers? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove a part of a cell
What you forgot to say, Bob, was that the "Find what" should be ~*, in other
words a tilde in front of the asterisk. -- David Biddulph "Bob I" wrote in message ... Click Edit, Replace. leave "replace with" blank BTR wrote: I have a long series of numbers which contains the asterisk symbol (*). How can I remove this symbol from these many numbers? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove a part of a cell
thanks
David Biddulph wrote: What you forgot to say, Bob, was that the "Find what" should be ~*, in other words a tilde in front of the asterisk. -- David Biddulph "Bob I" wrote in message ... Click Edit, Replace. leave "replace with" blank BTR wrote: I have a long series of numbers which contains the asterisk symbol (*). How can I remove this symbol from these many numbers? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove a part of a cell
PERFECT!!!
Thanks for the help "BTR" wrote: I have a long series of numbers which contains the asterisk symbol (*). How can I remove this symbol from these many numbers? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to remove gridlines from part of a worksheet only | Excel Worksheet Functions | |||
| can I remove part of a file name (LO) from a group of excel files | Excel Discussion (Misc queries) | |||
| remove hyphens from a list of part numbers | Excel Worksheet Functions | |||
| remove a dash from part numbers | Excel Discussion (Misc queries) | |||
| remove last character in a series of different length part #'s | Excel Discussion (Misc queries) | |||
Hybrid Mode
