text analytics

I want to import ,say, D column from .xls (not csv) file, data is range, not table. How to do that ? I found how to import named column, but not basic

Hi All, I hope anyone can help me with below request... I have data with filed called description and which consists of unique PO number and this line item not standard data, every line item which inclusive of special character different different numbers along with PO number. Example Data...

Hi, I have a HUGE table of data and one column is all kinds of names that need to be parsed. I found two common types of arrangement. Last Name Mid initial first name (IE: Doe P Jane), the reverse order of that (Jane P Doe), and some variant that puts the mid initial at the end (Doe Jane P...

I'm receiving a spreadsheet from a coworker that has a column of dates, these dates are inconsequential to me. I would like to have a formula that I can plug in that will conditionally format any cell in this column when there is any text in it to automatically convert the text to a simple check...

I conducted a survey and I am trying to return a value using index match. I am realizing that some of the text of the survey has been edited, so my index match isn't finding what it needs to. I thought I would have a better return rate if I instead of matching the whole cell, I would match just...

Hello! Guys, I need to do some work on a huge database and I will really apreciate if you help me to automate the most mechanical part. What I have: Cells with lists of fullnames in the first column ("Full list" in example). The cells contain fullnames as well as, sometimes, 'random'...

Hi, I have a requirement to prepare a macro to split a characters in a cell after 256 characters and transfer it to the next cell. example : (considering that I split for every 1 character) Input cell 1 cell 2 cell 3 ABC Output : cell 1 cell 2 cell 3 A...

Can someone point me in the right direction? I have a list of websites. www.server.website1.com www.website1.com www.server2.website2.inf website.info What I want do do is put the last two sections (example: website1.com) into a separate column so that I can start counting things that are the...

I'd like to use text string functions to retrieve 3 letters from the middle of a word, measured from x spaces in. For example, if my string is UNITEDSTATESOFAMERICA in A1, and I want to begin 5 spaces in, I can use =MID(A1,5,3) and it returns EDS But if I want to do this 5 spaces in from the...

I am trying to format the following formula but am not sure how to do it. In sentence form, I'm trying to say: If column/row C59=Tom and column/row G59=**** and Column/row K59=Harry, then column/row R59 =1 or 0 if false. =IF(AND(C59="Tom"*G59="****"*K59="Harry"),1,0) Additionally, what I'd...

In Cell A1 I have the text: As of March 1, 2014 In cell A2 I need a formula that obtains the result: 3/1/2014 Looking for a simple formula. Thanks

Hi, I'm trying to use the COUNTIF formula as per the title and, even though I'm using Conditional Formatting to bring up bold in the cell range, I'm getting 0. (I say 'even though' as I've seen on the boards that you must use Conditional Formatting for a COUNTIF to work.) I have a range of...

Hi, I have been working on this problem for a few days now and have tried multiple approaches with no luck. Any help is appreciated. I am trying to develop a spreadsheet that will reconfigure data from a varying number of rows into one row for each ID. I have been able to use pivot tables and...

Hello guys and girls, I just arrived on this forum and I think it is the best Excel community I've discovered until now. I am currently having an Excel issue. I have a table with mentions of a specific car brand from social media channels. I have to analyse the discussions and show the number...