1. E

    Excel Question: Line Split / delimiter on an empty row

    0 Example : I have a single cell (yes, single cell) that contains all this information. +---------+ | ghijkl | | aededd | | | | ededed | | ededfe | | | | efefeef | | efefeff | +---------+ Is there anyway I can split this into 3 cells ? +---------+...
  2. J

    Splitting a cell by delimiter with formula. Warning: 312 splits needed for this.

    Hi! I can't seem to find a way to split cells in Excel using formulas (I need it to be dynamic, so I can't use the built-in splitter). What I have is up to 8 rows and 39 columns put into one cell. It's easy enough to get them spread out when I get them split up, but I can't split them. I can't...
  3. Belair58

    Graphing from a $ delimited txt file

    Hello, I'm outputting a delimited txt file using $ as my delimiter from SQL server. This file will be output once every 5 minutes. I'm wanting to graph this data on a continuous basis. I'm trying to link it through Data / From Text/CSV, but it doesn't give me the option to choose the delimiter...
  4. Hawks18

    Custom List for Sort Order - Using Sorted Values w/ Commas

    So, I've got a unique scenario that I can't figure out and doesn't seem to have been solved elsewhere yet. Excel allows users to create "Custom List" data for sorting cells - unfortunately, these lists are inherently delimited via commas and it seems to be non-negotiable. Ordinarily, it...
  5. B

    Leaving empty cells if output is blank with a macro

    I have the following macro. Everything is ok with it, I just need to leave empty cell if there is no output (no values/numbers). Is it possible to do this? Can I get some help, please? Thanks. In the current code, if there is an output in the cell (eg 6), thats ok. but if there is no output...
  6. M

    Delete entire row if Colunm contains number between two values

    I have a table with product codes in Column H. I run the macro below to delete rows with product codes that I do not want to track. This bit of code uses and array to delete rows that are not in the array. It works without problems. Dim FirstRow As Long Dim LastRow As Long Dim...
  7. S

    Extract Numbers from Formula to Columns

    What formula will extract numbers from a formula using any operator as the delimiter? For example: <tbody> Invoice Amount Product 1 Product 2 Product 3 =4384+89463+9876 4384 89463 9876 </tbody> The invoice amount has a formula that is auto populated from our system and I want to...
  8. D

    how to use split function with unicode delimiter

    Hi, I have an excel sheet with comma separated Arabic values. The Arabic comma is Unicode U+060C , how would I specify a unicode delimiter in the VBA Split function? Thanks David
  9. H

    Copy rows based on a delimiter in each column

    I have a requirement as below: Each row might have multiple data (comma seperated). Based on comma as delimiter, I want to have those many rows inserted below and each row should have one color and one data combination. Can someone please help me on this. In the below example,where Red has 3...
  10. F

    how to extract data between first and 2nd last delimiter.

    Hi All, I would like to know if there is an excel formula to extract data in the middle between first and 2nd last delimiter. I have a sample data as below. device_hostname1_rootvg_lun1_1_vol device_hostname1_vgDBapp_lun397_1_vol device_hostname1_vgDBbkp_lun398_1_vol...
  11. Dr. Demento

    Edit character AFTER delimiter and then delete delimiter

    I'm trying to adapt a function that currently uses Range.Characters and replace it with something that can be done in array. I had some ideas but it doesn't appear they were feasible. I did have one thought that I think is doable but I need some direction. I pose my myriad of questions here...
  12. I

    Text to column by multiple delimiter characters?

    Is there a way to split text to column using multiple delimiter characters?
  13. bencar

    General Formatted Numbers Refuse to Format into Dates

    I got dates on excel in general format form. I want to format them to actual dates. I tried formatting them as dates but they stay the same so it doesnt work. I read about delimiter but I tried it and that doesnt work either or maybe I'm not doing it right. ANyway here are the dates: 31.03.14...
  14. S

    need to find the text length of 10 character CAPS AND NUMBER and put ^ delimiter BEFORE AND AFTER

    i need formula OR VB CODE to put ^ delimiter to the text below EG--TEXT IN EXCEL = Comprehensive Insurance CI25874567 4000 1 Year richard Pendergast 101 Delia St OUTPUT ---Comprehensive Insurance ^CI25874567^ 4000 1 Year richard Pendergast 101 Delia St
  15. M

    Splitting Text File based on a delimiter line

    Hi All, I have a number of very large files that I need to split up based on specific delimiter lines in a given cell. However the delimiter is not a uniform number of lines apart. The basic format of the file is: <delimiter line> <Name line> <Text Line> ... <Text Line> <Delimiter line> With...
  16. B

    Error Splitting Column By Delimiter - Update Related?

    I had a query that ran perfectly for months until I installed an Office 365 update yesterday. I am now getting an error that 'This query is too complicated to run'. I stepped through my query and the error appears when I split the column by a delimiter. After some trial and error I noticed that...
  17. J

    Split By Delimiter Without Changing New Column Type

    I am looking for a way to use power query to split column by delimiter without it automatically changing the new column type based on what it contains - I want it to remain as 'any' for data type. The reason being, I have an input box that takes in bits of information separated by commas, and...
  18. G

    Need to isolate the 4th segment in string

    I have a strings of data that often look whats below, I can isolate the first segment and the last segment...but I can't get the middle segments. The number of spaces can vary and it's turning out to be a nightmare. Forums/Google haven't yielded results (I may be looking for the wrong thing)...
  19. B

    Combine userform checkbox & textbox into a string/loop in a single cell

    Hello there. As it is probably obvious, I am super green on attempting VBA. But since I have some time, I have been exploring it to streamline processes at work. Here is a small background about my dilemma: My userform is going to be used to grade employee training with the results being added...
  20. C

    VB Export to Notepad with Customer Delimiter

    Has anyone done this? I've been googling for a while and haven't found anything apart from messing with your system settings and changing them back afterwards. I need to export the whole sheet to notepad using # as the delimiter I can't use , as the sheet contains a lot of text which uses ...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

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
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 "".
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.
Go back