Search results

Thanks for the VBA Solution. This got me what I needed. Thanks again.

The data might increase, but I don't expect it to, but do expect some minor value changes.

With the number of columns (400+) the multiple queries is going to get messy. This will be something that I'll need to create over the next 6 months. I have minimal experience with VBA, but will have to look into it.

I tried using the Transpose feature in Excel. It moves the header row to a column, but the numbers are in a single row instead of a column.

I have data that is in Format A and need the data to be like Format B. There are 400 columns in Format A and 19 rows. How can I get the data into Format B? Format A: This is the format that the data is in HRS-Billing MLTC - 14200 Indianola 3881229 18211 \+15551056305 28393 \+15551018287...

I type is a .xlsx. I tried uploading the actual .xlsx file and the site doesn't provide attaching the file type. As you stated, Excel is consistent in how it formats cells. The more I've worked on this the more it looks to be coming from the source system file. I've got an engineer looking at...

They are all from the same source.

I have a file that is a system export. Some of the times are formatted in hh:mm:ss format and I'm unable to change the format. Any ideals on how this can be changed?

Success, thanks for all of the help. Pulled a new file, imported it, used the statement above and presto, the field was populated.

I tried your suggested statement and it wasn't successful in writing to the field. Agree on the space in the naming, the entire header row from the import is that way :-( I did an ISBLANK statement in Excel to see what it returned and I got a zero value in the field. So, I'm thinking that's...

I've been running this query IIf([Agent Name] Is Null,"NoName",[Agent Name]) to write NoName to a Null field. Recently, the statement will not write the value in the table with the Null field. I import the table from Excel and have used the LEN statement in Excel to look for hidden characters in...

CJ, My apologies for grabbing an old post, it came up during my search. The comment, I have this in Excel and there are 74 columns that represents the 74 OU's. with the various security groups.

I have data in the following format CN=AAD-VPNMFA-ALL,OU=Security Groups,DC=myhouse,DC=corp,DC=com and want to remove everything to the right of the first comma. In Excel, I can do the following =LEFT(B2,FIND(",",B2)-1) and everything to the right of the first comma is removed. This works but...

Awesome, thanks so much for your help.

Plog, Thanks for your help. This works with the exception of the string that do not have the * in the string.

Query returns Data Type Mismatch in Criteria Expression

Running the RIGHT(string,n) function removes the characters, just the varying length that it doesn't cover.

Yes, I want everything to the right returned

I've got a data string that has an * in it followed by a comma with data with characters after it. I need to remove the * and all of the characters to the right after it. The range of characters vary in length. Data Sample; CSQ_ACNY_Team1*, CSQ_ACNY_AllOther CSQ_ACNY_Team1* I've tried using...

For me and my family, we're all doing good. Just being in all the time is a bit of a challenge, but like all things, this to will pass. I pray that all of you and your family is going well.