| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I said "Keep this text! Not a date!"
I have a column formatted as text. I have data that looks like this: " through 5" or "2 through 14". My macro does a find and replace: Range("D2:D100").Replace _ What:=" through ", Replacement:="-" My result is not what I want; it gives me dates. Desired outputs ar "1-5" or "2-14". What do I need to do to accomplish this -- pikapika1 ----------------------------------------------------------------------- pikapika13's Profile: http://www.excelforum.com/member.php...fo&userid=1089 View this thread: http://www.excelforum.com/showthread.php?threadid=55617 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| How to transfer "text" into "date"? | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
| How do I split "A1B2" into "A1" and "B2" using text to column fun. | Excel Programming | |||
![pikapika13[_10_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
