Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
All,
I am extracting a certain column of data from an Excel file (a . Unfortunately, some of the data was entered incorrectly (i.e. there should not be any data present in-between a '.' and a '+', nor should there be any occurence of a '.' before a '+' Example: 282_994.01+282_995.01 needs to be changed to 282_994+282_995.01 A hard-coded find & replace will not work because there are so many different offending text strings. What I simply want to do is find any occurence of a '.' before a '+' and eliminate all text from the '.' up to (but not including) the '+'. Any help is much appreciated. Thanks! -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I restrict a text column to a specific number of characters? | Excel Discussion (Misc queries) | |||
How to extract specific text from a string of characters | Excel Worksheet Functions | |||
Macro that returns a specific number of characters from a text str | Excel Discussion (Misc queries) | |||
Text String - Specific Characters | Excel Worksheet Functions | |||
how do I highlite text within a cell (specific characters) | Excel Discussion (Misc queries) |