text

Hi, I tried to simplify my issue: I wrote in my cell C2 the following formula: '=SUM(1;2) When I copy paste this formula in cell C4 I can read =SUM(1;2) in the cell but it does not calculate it. I need to click in the formula and just press enter for it to calculate. I assume the quote is...

I would like to box parts of text within a cell. I know it is possible to format the font of partial cell contents but is it possible to box it. I have attached a picture of what i would like but in just one cell. using Office 365

i dont seem to make progress bcs I dont have experience. Maybe you guys can help me out. If a button is checked i want it to display the text in a free cell from A1 to A14. I tried .TypeText „…“ but that does not work. Help is much appreciated

I've formatted my cells as time. When I enter 3:15 Excel converts it to 3:15 AM. That's ok. But if I input 3:15 PM Excel accepts it as text. If I type 15:15 Excel properly converts is to 3:15 PM. I have no idea why I can't type the AM or PM and have Excel accept the value as a time.

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...