All Questions
751
questions
0
votes
0
answers
29
views
Need Help Comparing Text in One Cell To Another
I am trying to develop a program where the end state will be this program finding all instances of similar text within cells from multiple sheets and grouping it together. This question is going to ...
0
votes
2
answers
56
views
Excel: How to extract a certain word, from a list of words, from a range of cells?
I'm looking to extract the varietal type of a wine, from a list of wine names. There's no formatting consistency. I've got a list of 8 potential wine types (shiraz, rosé, chardonnay, etc.) and about ...
-1
votes
2
answers
58
views
Wondering if there is a way to auto format pasted text entered into a cell to 1) delete paragraph spaces, and 2 ) to limit characters per line
Wondering if there is a way to auto format pasted text entered into a cell in excel to 1) delete paragraph spaces, and 2) to limit characters per line via wrap after a certain number of characters. I ...
0
votes
1
answer
63
views
Replace text in cell if specified text in another cell in same row
What I want.
If a cell in column D says emilio pucci or max mara or tom ford and the word sunglasses is in column H within the same row then replace what is in the cell in column E with Marcolin.
If ...
-1
votes
1
answer
66
views
Excel chart text on Y axis
and @Jon Peltier [tag: Jon Peltier ]
I have an Excel chart that I am trying to put text on its Y-axis. However, since I have four values/text, I cannot use the custom option.
If anyone can help, it ...
1
vote
4
answers
64
views
How to return text and not just numbers with arrays in Excel
Yesterday I was so fortunate to receive help on a question (How to work with IF/IFS/ISBLANK when columns contains zero length strings), which yielded the following answers:
=BYROW(CA6:CC13; LAMBDA(a; ...
0
votes
1
answer
63
views
Import a text file to Excel using VBA on the same sheet
I want to import a text file into the current Excel Sheet.
Code I found keeps the text as I want, however it opens a new Excel workbook and pastes it there. This isn't ideal since at times I'll have ...
0
votes
2
answers
36
views
How to convert a text with data in series having field name on left to a table in Excel?
I need to convert a dataset in series to a table in Excel. The dataset has field names on the left side in order and each dataset is one after another vertically. I want to have a common primary row ...
0
votes
0
answers
41
views
VBA - Text Variable transferred into number
in my VBA code I'm saving a variable as string because I need this to be open to text - numbers - date like numbers.
I then need to copy this into a table.
When copying the first time the variable ...
0
votes
2
answers
116
views
Find specific text in range and change font color
I'm hoping someone can help me with VBA code to search for specific text in a cell range and change the font color to red.
For example, I'm looking for the word "cat" but I don't want any ...
0
votes
1
answer
59
views
VBA - Sorting text file by number sequence of 20 characters each
I am trying to sort a text file from VBA, using Wscript.Shell.
However, I am unable to sort by the first 20 characters of each line. It's as if the command only considered the first 10 characters to ...
0
votes
0
answers
83
views
How autofilter column with specific text and numeric values?
I have this range, say, A1:H2000, that needs to be filtered in column A - i have two different critera for this filter as following:
criteria 1 - array("C1","C2", "C3")
...
0
votes
1
answer
310
views
VBA Paste Plain Text To Outlook Email Body
I currently have a working VBA code that pastes a table as HTML into the body section of a new outlook email. The HTML seems to be causing some issues for the engine reading these emails, and so I am ...
1
vote
2
answers
80
views
Export data from selected cells into txt format
I have data in a cell which has an equation linked to another cell.
After exporting it is unable to find the values so it is writing # Ref in said text file.
Also it is writing ";" (...
0
votes
1
answer
199
views
DAX functions in EXCEL Pivot
I have a Table as data range for a Pivot Table. As I am using some text in the Data range I've created the Pivot Table, adding the data to the "Data Model"
The data column I am to be working ...