-2
votes
1answer
169 views

Extract Mobile Numbers from text file Starting with 0300 or 0321. Like 0300-XXXXXXX, 0321-XXXXXXX [closed]

How can I extract only mobile numbers from my text file? Mobile numbers format is 03xx-xxxxxxx. Text is something like this: 1 Mr.Pervaiz Ahmad Latifi Rajput Traders, W/571, Ratta Road, Near ...
1
vote
2answers
203 views

How to import this data set into excel? (column headings on each row delimited by a colon)

I'm trying to import the following data set into Excel. I've had no luck with the text import wizard. I'd like Excel to make id, name, street, etc the column names and insert each record onto a new ...
1
vote
2answers
2k views

Merge Excel rows from two sheets

I'd like to start this question by apologizing, there are numerous questions about merging excel rows, still, after browsing the web AND the list of "Questions that may already have your answer", I ...
0
votes
4answers
2k views

RegEx to Remove CRLF from CSV export from Excel

I exported an Excel File to CSV and do have a lot of multi-lines within. I marked the beginning of each line with * and the end with ###. *** some text within my cell to export ### Could someone ...
1
vote
3answers
963 views

excel vba - multiline regex not working

In cell A1 of an excel sheet I have the following contents inside the cell: select a.id, b.type, c.name from blah a, blah2 b, blah3 c where a.id = b.key and b.key = c.id ; Either of the below ...
2
votes
2answers
4k views

How find & replace using wildcards with regex substitution?

Is there a way to use regex substitution with Excel find & replace (in the GUI)? Using a JavaScript example, I want to do something like this: "John Smith".replace(/(.*)\s(\.*)/, "$2, $1") // ...
0
votes
2answers
283 views

Regex in excel: Fixing dates, from Apr 1/11 to 1-Apr-11

I have a fairly large spreadsheet and the dates column hasn't been locked down with an input mask/format and users have been using an incorrect dating scheme. Users are inputting dates as Apr 1/11 ...
9
votes
2answers
8k views

How to find and replace the character “*” in excel

I am trying to find and replace the * (star, or shift+8) character in a bunch of formulas in Excel 2007. * of course matches the ENTIRE contents of the cell, which is not what I want. How do I ...
1
vote
2answers
354 views

cut text from each line in a txt file

i have a text file where each line looks like this: <img border=0 width=555 height=555 src=http://websitelinkimagelinkhere> each line is like that for like 1500 lines, i want to sort of ...
10
votes
4answers
26k views

Can you do Regular Expressions in Excel without VBScript?

I'm looking for an Excel function that I can put in a cell to do a regex search of the contents of another cell. Is there anything available to do this? I'd prefer not to have to add VB Script to ...
2
votes
1answer
1k views

Why does my regular expressions invoke error '5018' in my VBA script in Excel

I just wrote my first VBA script for Excel because I have to write many "*.txt" files from a folder into an excel spreadsheet. But when I run this script, I get the error '5018'. It is invoked by the ...