text

I am working on two sheets and I need help finishing a formula to text to formula function. Sheet 1: Cell H48 formula: =CONCAT(TEXTJOIN(",",TRUE,H2:H47),",""""",J46,) Cell H48 output (Text)...

Hello. I am very new to VBA so i have a question. How do i change number format of the value for textbox total cost? i know afterupdate but i tried and it work only on textbox that the user input data in but how do i change the number format of value that is calculated from data input by...

hello, community. I'm trying for 2-3 days to make a Microsoft Access Database for a schedule at my work - 24/7 x6 people. it's too hard for me and I'm back to excel. at the moment I'm trying to bring the information (text) from sheet 2 to sheet 1 but i want to keep the text formatting ( only...

Sub Import_Text_Files() Dim FilesToOpen Dim x As Integer Dim wkbAll As Workbook Dim wkbTemp As Workbook Dim sDelimiter As String Application.ScreenUpdating = False sDelimiter = "|" FilesToOpen = Application.GetOpenFilename _ (FileFilter:="Text Files...

Question is there a formula for the below example? From this: Queue Name Order No. Jack N01 Jenny N02 Jenny N03 Kimmy N04 To this: Queue Name Order No. N01Q01 Jack N01 N02Q02 Jenny N02 N03Q03 Jenny N03 N01Q02 Kimmy N04 1. So A2 gets the value of C2 and add...

Hello I'm trying to import a text file into a specific sheet, where it should do a Text to columns with the delimiter set as a space. What I would like to do: Clear all data in Sheet "SVKData" File Prompt for a text file, that imports data into "SVKData" the data should just be imported into...

Hey everyone, I wrote this bit of vba quite some time ago (2017) to run a little bingo caller for a social team where I was - keeping excel up to date wasn't something they were good at - so the version at the time worked. They have now updated to O365 and the reformatting of the text in the...

Hi, I'm doing my first post here. Please excuse me if this is silly. I have col A and col B as text fields. In col C I have a query list. I'm trying to find if the text values in both col A and col B exist anywhere in col C and then return a true or a false. Please see the attached sheet...

Hi! First time posting here! I have been struggling with a very specific and probably weird issue that I am not sure of having a solution. The problem is related to text that is initially in word documents. Likewise, I have today asked for advice in a forum connected to Word VBA...

Hi, I am using the below code to Generate a text File in pipe Delimited format. Sub ExportTxt() Dim UsedRows As Long Dim UsedColumns As Long Dim R As Long, C As Long '// Define a suitable file name Open "E:\Folder\" & "TD.txt" For Output As #1 With ActiveSheet...

Hello, I have a table with some columns, and I would like to make some text below it connected to some cells. Example: Name Number Street Age Bob 2 Close 24 Rob 3 Far 64 Robert 5 Near 32 Bobert 7 Here 24 Idea is to place below something like this: Range("A6").value="Hi"&"...

>10k of rows of short sentences have within then, usually, a code. I need to extract this code, but how do I get PQ to recognise its format, which is: 230F-115-04 301F-115-05 30A-115-26 30F-1180-02 30F-118-03 30F-1252-04 130H-1252-05 30F-1252-18 30F-126-01 40G-127-01...

Hi guys, Long time lurker, first time poster here. I'm working with results from a SharePoint survey that allows the respondent to check multiple boxes for a single question. In Excel, such answers are concatenated in a single cell with delimiters. For example, one answer could be...

Hello, I found something that is close to what I need, but instead of returning True/False, I need the actual word. Please see screenshot as an example. And here is the link close to find I need, but returns T/F. Cell contains many things Thanks!

The TEXT formula can be used to show numbers as text. The cell which has the TEXT formula can be used in future calculations as well. In the example below the number is rounded to 1 decimal place. If there were hundreds of these cells to be summed, the result will have accumulated error. Is...

Hi guys, I've been struggling with this for a few hours, not certain if I'm dumb or not lol. Assume I have a cell with text. I need to check if any of the values within a specified range are inside that cell. Ideally return that value within the range. Example: Cell content = "I have this...

I want to concatenate 2 columns so that text appears after a date and the date formatting does not change. When I do, the new column converts that date to text and generates a new text "44224-text". Is there a way to display the "date-text" while maintaining the date formatting? example...

Hi there, I have a list of employee names, which are also accompanied by date and location information (see example). I would like to quantify how many relationships exist between the names on the same day/location. In other words, how many times has each employee worked with every other...

Let me give you an example : Image=Image1 Image=Image2 Image=Image3 TextImage=Image1 CSVImage=Image2 StringImage=Image2 I have a text file containing these words. How can i delete lines from this text file which contains "Image=" in its line i.e. Line 1st,2nd and 3rd should be deleted but Line...

HI, I'm trying to do the Median equivalent of AVERAGEIF(A1:A10,"*"&C12"&*",B1:B10) where Column C has text some of which is contained within a longer string in Column A and Column B has numerical values that I want to find the median of. I found other threads where this was possible with the...