Hi Guys,
I'm finally playing around a bit with regular expressions but have had limited success.
To practice, I've been trying to get a list of all unanswered Questions from the Excel TA. So ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/05/2006 Rating: 7.8 Views: 0
This thread is for general discussion about all things related to the Excel zone and its Experts. Topics welcome include:
- Asking for assistance with specific questions.
- Excel issues, announ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/02/2009 Rating: 3.4 Views: 0
I have a cell in Excel that contains a long string of text. The text looks something like this: "Jan 2008, Bob Jones - 176hrs, Frank Miller - 180hrs, Harry Wilson - 169hrs".
I'm trying to use r...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS Excel,
Re...Date Answered: 02/25/2009 Rating: 8.2 Views: 65
I'm trying to parse text in one cell of an Excel spreadsheet using regular expressions. The text looks like this:
Jan 2008, Bob Jones - 176hrs, Frank Miller - 180hrs, Harry Wilson - 169hrs
I wa...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS Excel,
Re...Date Answered: 02/25/2009 Rating: 9.0 Views: 0
The linked solution is solution is similar to what I want however I need it delete the duplicates rows if the cells contain a common word.
Example:
log inbound and outbound home calls
cellpho...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
What I want to do is take a chess .pgn file and convert it to print out in column form by running a Word or Excel macro.
The raw.pgn file looks like:
[Event "Team 45 45 League T35"]
[Site "...
http://www.experts-exchange.com/Programming/Languages/Regular_Expressions/Q_22981224.html
I want to install Regular Expressions designer software, to help me create Regular Expressions rather more easily. So my question is in two parts:
Please provide me with a links to a download si...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_23621720.html
Zones:
.NET,
MS ExcelDate Answered: 08/05/2008 Rating: 9.1 Views: 8
I have a large file with 11000+ rows with company names. The all have (dutch) legal forms such as B.V. and N.V.
I have written a RegEx which selects the right parts of the cell values. I need to p...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_23936624.ht...
I have a lot of webaddresses in a excel sheet. I want to remove the parts '(http://)www.' and '.com' to i only get the url name.
I have a macro which does this but i want it to work only where col...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_23936863.ht...
Back again :)
This time i have a column with a lot of city names. These are all in uppercase. I've written a macro which turns them into proper case text. Some of the cities have strange names w...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_23941820.ht...
