All Questions
Tagged with extract microsoft-excel
19
questions
1
vote
1
answer
2k
views
Extract text using RegEx without VBA
I have the following text, and I'd like to pull the PO number. Sometimes it starts with the words PO, sometimes it doesn't. If it doesn't, then PO number will start with either 901 or 902.
PO or PO ...
0
votes
1
answer
1k
views
Removing date from datetime (VBA Excel)
I need to delete the date from mulitple rows with a datetime value. Or extract the time to another cell.
For example:
A1 = 3/11/2022 10:20:00
A1 after macro = 10:20:00
or
A1 = 3/11/2022 10:20:00
A2 = ...
0
votes
2
answers
2k
views
How to extract numbers from string and separate them by comma (or other separator) (substitute, replace, erase, isnumber, remove, delete, ...)
I need to extract numbers from a string in Excel and the numbers need to be separated by a comma as shown in row 3 (or any other separator).
I can extract the numbers in row 1 by:
=SUMPRODUCT(MID(0&...
0
votes
1
answer
384
views
Extract MID between characters, but from second instance in Excel
I need to isolate the middle string of text from a line. The number which follows the "Q."
"400"
When I pull the MID section, it grabs everything from the FIRST "S" to the end of the "Q400"
...
1
vote
0
answers
76
views
Extract rows into a limited template based on multiple criteria
I have an issue in extracting from "Datadump" into several continuous "Template" (as the template can only contain 10 rows of item).
Here are my intentions:
From the data dump (sample above), is it ...
0
votes
2
answers
1k
views
Excel: Column comparison with dates and values
I currently have 4 columns that contain data on Bitcoin Prices and S&P 500 closing day values, as well as their respective dates:
Since the S&P 500 is closed on non-trading days and the ...
-4
votes
2
answers
1k
views
Extract Numbers after a specific word in a cell/string, to different cells
I want to extract the price/rate from the below string.
"38A Standard - HotelCollect 2019-01-01 Per Day Rate CAD 99.00 2019-01-02 Per Day Rate CAD 99.00"
I want to extract the rate that appears ...
0
votes
1
answer
2k
views
Extracting multiple email address from excel cell /excel file
Is there a way to extract multiple email address from excel cell /excel file
| A | B
----|-------------
1 |HTML |
|...
1
vote
3
answers
4k
views
Extracting Data Between two Different Characters in Excel
I have data in the following format in Excel:
ABC - DEF - XYZ; GHI, JKL, MNO, PQR, STU, VWX, YYY, ZZZ
Is is it possible to extract the data between the second hyphen "-" and the semicolon ";" - in ...
0
votes
1
answer
1k
views
Read Excel Macros Programmaticly in PHP or JS or Another Language
How to extract macros in Excel file in PHP or JS?
I found https://github.com/PHPOffice/PHPExcel/ but there is nothing about macros.
0
votes
2
answers
3k
views
Is it possible to extract url from hyperlinks in excel if it's setup like this?
I have few hundred lines like this in excel file. I have tried to copy them one by one and it's very tiresome; so I am wondering if there is a away to extract the urls from all of them at once?
<...
-1
votes
2
answers
12k
views
Excel, How to extract records that are all in one column
How can I extract all the records stacked into a single column and rearrange into a 'normal' table with records in rows and fields in columns? Data is "vertical" because that was arrangement in .DOC ...
1
vote
2
answers
87
views
extract in same column cell with different format
I need to extract value in same column that have different format (date and text) as showed below:
09/02/80
23/12/73
ANA
ANA
11/03/83
11/03/83
07/07/34
How could obtain from one column two separated ...
0
votes
0
answers
79
views
Extract numerical data from MS Word graph [duplicate]
I have a word document that includes chart objects linked to data held in unknown spreadsheets that cannot be accessed.
The charts are 'frozen', in the sense that they are displaying the data ...
2
votes
1
answer
2k
views
Excel: extracting a number from mixed content cell [duplicate]
How would one extract a number starting with a "£" sign from a cell containing alphanumeric characters?
Example: extracting £450,000 from A1 and placing in B1. See image for example text