Greetings Excel Community,
I have a set of data and i am wondering if there is code or formula that can be created to parse these values into comma delimited dates. The dates are combined together to make it look as a long string, however i am attempting to create the end result under the...
Hello,
I've been struggling with what I thought would be a basic Macro, would appreciate some guidance if possible.
Our CRM spits out an excel sheet of hundreds of rows similar to the one below.
Unique Item Number
Item
Item Description
Code
Quantity
Units
Value
Currency
Weight
Weight 2...
Hi all,
I currently have a very messy sheet that looks like this:
Essentially, row 1 is the heading, row 2-3 is the results that I want to produce through a text to columns, and rows 24-45 are the data that I currently have.
The issue is that my cells have become messed up, so for every...
christian røssel
code
comma
conditional formatting
delimeter
excel
excel &
ez sverk
ezz
formula
help
jonas sværke
macro
olzenmedz
record macro
sanoj ekrævs
sonaj jværke
sverktallica
svorktallica
text to collumns
text to columns
textjoin
vba
vlookup
Greetings,
I am analyzing protein sequences, and wanted to use Excel's tools to facilitate the analysis. For that, I wish that all amino acids (1-letter abbreviation) occupies its own cell. The main problem is that the sequences come without any delimiter, and they can be quite long (hundreds...
I have example data that is structured as the below with aggregated values on the end in one cell. I'm hoping to split this out into each record if it is split with a comma, space or pipe. The intended output of it would be to use vba to show it the column with the separated values and then have...
Hi,
I have long list of files in .dat format that I want to convert them into excel format. The files have bunch of data separated by delimiters and I need them to be separated by columns in excel. I know the excel trick where I can import the data in excel/or open with excel and use the...
Hi,
I was able to return multiple values into one cell; however, I am trying to figure out how to change my delimiter from"," to Char(10):
For i = 0 To DEPListBox.ListCount - 1 If DEPListBox.Selected(i) Then 'If selected is True
strTemp = strTemp &...
Hello, Im having trouble importing a csv file. The first row works fine, but the rest are all wonky. Here is a sample of the first and second row from the csv:
"Order # ","Purchased From (Store)","Purchased On","Bill to Name","Ship to Name","G.T. (Base)","G.T. (Purchased)",Status...
let's say I have a cell A1 contain 2 values input as (1,3/4), I want to separate the values into other columns like B1 (1) and C1 (3/4) using the Text to Columns delimited feature. However, it keeps showing me as C1(4-March) even though I formatted original cell to text format already...
Hi
This is my first post. I hope that it makes sense. I export a sales csv from my website which contains all the address information for the various couriers that I use. Recently orders overseas have increased and I am forever filling in CN22 forms, so I decided to also export out item...
I have an output that puts multiple names into one cell. The names are in the format "LASTNAME, FIRSTNAME, LASTNAME2, FIRSTNAME2...)
I need to split the names up and with first and last name separated by a comma, I can't use the delimiter as a comma.
How can I approach this? Any help is...
I have an excel sheets which contain information which will be exported via CSV in Excel and later be imported via CSV into a mysql database.
The problem is that some columns in the excel can contain quite a few common delimiters such as commas, apostrophes for text fields, along with single...
Hello everyone! This is my first post and it has been a rough few days trying to make this work.
I run reports that tell me when an individual is supposed to be in the office and when they actually log in, but this is a manual process where I have to go through several hundred people each...
I am quite comfortable with Excel, and have used this for years. I perform a lot of text manipulation, often taking data from external sources and pasting into new worksheets. I used "(" as a delimter once about a month ago, but now I've found in ANY new file I create or new data I paste into a...
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.