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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.