Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mixed Text & Numbers
I have a row of numbers, which can be 2 or 3 digits long. Some have * before
the numbers, some don't. I want another cell to be able to read the numeric value if the cell has an * before it. Any ideas? I'm stuck. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The order of numbers mixed with letters | Excel Discussion (Misc queries) | |||
how do I sort a column mixed with odd and even numbers .. ? | Excel Discussion (Misc queries) | |||
Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
Sort mixed numbers/letters | Excel Discussion (Misc queries) | |||
Incrementing Mixed text & numbers | Excel Discussion (Misc queries) |