imported

I noticed something odd today and I don't know if this is new or if I just never encountered this before. I have 3 files in a folder and imported from the folder into Power Query. 2 of the files have 2 columns, 1 file has 3 columns. Power Query imported just the first 2 columns from each...

Very interesting. The data is imported from another source like this: 48 Limestone St.Markham, ON L6B0P6 (no space after St.) When applying Wrap Text it shows up as: 48 Limestone St. Markham, ON L6BOP6 When I use =Left(cell, 18) or =left(cell,17) I note that the result is the same - 48...

Not sure if this is possible, but I will ask anyway. I have a worksheet that gets data imported from a survey form This data is imported into Sheet 1 Row A1 through to A12 What i would like to do is once the data is imported, is to copy it to Sheet 2 rows A1 to A12, so I delete Sheet 1 info...

I have a sheet that i want to import data to (sheet1 B2) this data is seperated by a comma i want to seperate and create it listed in a single column on (sheet 2 B2, B3, B4 etc) can someone please help with a formula thanks in advance

The answer to this may be just a flat no!, but I am looking for a way to allow a data validation to be imported to another sheet and be edited by that sheet. Here is what I am looking at: Cell A is a reps name, Cell B is a customers name, Cell C is the result. Each rep has their own sheet...

Hi all, I have a date that is being imported into my spreadsheet and comes as a long text that I want to convert to dd/mm/yyyy An example of how it is imported is this "Monday 3rd Jun, 2:10:40pm" What I want to do is get rid of the time and convert to just dd/mm/yyyy. Is there a way to do...

We have a file that runs a few times everyday (m-f). For the ones that run in the afternoon depending on the size of each file it could end before 4:00pm or after. The file puts a end timestamp. After importing to Excel I use this formula to extract the time from the file...

In my Excel file, I have imported many txt files with tab delimiters manually (Data tab -> Import data -> From Txt). Each txt file is imported into its own separate sheet. The delimiters are recognized and the data within each txt file is neatly imported into separate columns, as shown in the...

Hi there. I have imported a file and column C looks like time but it is not. I have tried to format the column to time but it didnt work. Im trying to get an average of column C. If i manually type the time in column D then im able to get the average time but just copy, paste & format does not...

Hello everybody. I'm struggling with sums. I mean: I've just imported data from an external source. https://imgur.com/a/7ln2Ti6 As you can see in the image, in the column "Amount" I've imported number, but if I select all (or apply whatever formula), nothing happens in terms of calculating...

I'm using excel 2016. I needed to import data from another computer that uses excel 2007. I used the import wizard and the data was imported as needed. The problem is now whenever I open excel or another workbook, a workbook also opens that has the data I imported. Why does this workbook...

I've imported records to a table to take the record count to 90,000. When I open a Form I have which has been used for the previous records (previously 48,500) it is only displaying the previous records and seems to be ignoring the newly added records. I added the records yesterday thinking it...

I want to bring cost of the product based on local and imported files please help me to apply vlookup. Summary Code No. Cost. A 40 B 50 C 60 D 70 Local Code No. Cost A...

Hi, 1: I have an Access DB that I use to copy Worksheets X, Y, Z from WorkBook 1 to WorkBook 2 (WorkBook 2 already has Sheets (A, B & C). objWBSource.Worksheets("MySheetName").Copy Before:=objWBDest.Sheets(1) 2: I save and close both WorkBooks. 3: WorkBook 2 then has sheets A, B & C and the...

This is weird. I have a worksheet that is generated by another piece of software (it's web-based, I don't know). On this Excel sheet, I have: Conditional formatting that changes the fill color and the text color Text that, after it's been imported, I manually change the color An imported...

I'm using this to replace the subject in an outlook message; Item.Subject = Replace(Item.Subject, " - IMPORTED", "") Can someone show me how to take it a step further and remove not only the above but any text after 'IMPORTED'?

Hi all, I have some imported data and rows 5 and 6 need swapping, the imported data can contain different amounts of data meaning that the number of columns used can be different. I have tried the following but can't seem to get it to work Sub Macro3() Dim LastCol As Long With...

Hi, how do I check, with a macro, if a .txt file that I have imported in Excel, contains some word? If it contains them, I need to show a error message, if it does not contain it, it's fine. When the file txt is imported in Excel, it is in the worksheet "Import". So I can check in the column A...

I have a cell with 5581004490451CS: 200. I don't want the whole text displayed (it was imported from a database). I would rather it display only "0451CS: 200" Any easy ideas?

Hello, I am trying to get the following formula to work on a table that it imported into excel from a sequel report and loads as a table =COUNTIFS(checksmart!$M:$M,'Mortgage RM...