split columns

  1. E

    Split Column to text in google sheets custom

    I need to split the column into text please can someone tell me how to do this in google sheets <tbody> AJANTPHARM19JAN1180CE CE AJANTPHARM 19JAN 1180 ADANIPOWER19AUG65CE CE ADANIPOWER 19AUG 65 APOLLOHOSP19AUG1400CE CE APOLLOHOSP 19AUG 1400 </tbody> Above is an example of how the column...
  2. G

    Excel TABLE - VBA to move cell from one table to another

    New to VBA and trying to piece together a macro but the table part is causing me problems. I have multiple "3 or 4 column" tables on a worksheet. I want to move a cell value by Double Clicking the cell on one table, then click anywhere on another table to move that cell value to that table...
  3. J

    Split multiple text in individual cells and count them as separate instances in chart or pivot.

    <tbody> Name Reporting period Condition Location Feed ID1 June 18 headaches, dental, eye UK Nil ID1 June 17 blood,urinary, dental UK Nil ID2 June 18 brain, blood, urinary, dental US Tube ID2 May 17 brain, urinary,dental,eye, US Tube ID3 April 18 eye, dental Can Drip ID3 April 17 eye...
  4. A

    VBA to Split file into multiple CSV files based on Column

    Hi All, I have a file of received items in the company. I need to split the File into CSV files based on the Scanner Number (HHT Name). The main in this is like I would like to select the columns only which columns need to be exported in csv (from 3 -6 columns based on the Brand, with or...
  5. J

    Split String into 2 Columns by 40 characters and 800 characters, Whole Word

    I have 90-120 character strings in Column A. I need Column B to take the first 40 whole word characters and Column C to take the remaining characters up to 800. I have been researching a solution to this problem and everything I have seen has been slightly off from what I am looking for. I am...
  6. D

    Split Column By Position

    Hello Any help here appreciated. In M, I am trying to reference a numeric value in a column as the number of characters to split a column by, but I am not sure how to do this. The value I want to split by is in Column 5 and the Column I want to split is Column1. I came up with this...
  7. G

    Splitting a 2013 Excel workbook

    Hi, I would like to split an Excel 2013 Workbook vertically at Column N so that when I filter data to the right of Column N the data on the left of Column N is not effected i.e. the rows are not hidden. Is this possible and can anyone help? Kind Regards Garry
  8. S

    Power Query - Split by Space - Except text

    Is there a way to split by space as a delimiter but only if the space falls between a number? So you got some poorly formed excel that has all the data in one column an example I created this. Because if people have different or hyphenated names then that will throw it off so if we can get...
  9. J

    splitting 1 sheet into 3 based on value in column AO

    I have a spreadsheet with a formula in column AO which returns 3 results "TRUE","FALSE" or "No KB" i need the entire rows for the whole of my "report" sheet to send the data to their individual sheets depending on what is in AO. "TRUE" to sheet "Matches" "FALSE" to sheet "No Matches" "No KB" to...
  10. K

    Question about splitting cell/column

    I have a column in my spreadsheet called Model#. The format of these model numbers look like this: T Bold 5000.FX.B The dots are basically separators. I would like to copy over these model numbers to another column but remove the last dot and whatever that comes after it. For example: T...
  11. B

    Split a column with no delimiter

    I have a spreadsheet that has 2417 cells of web page id's in column A. (example:<table border="0" cellpadding="0" cellspacing="0" width="328"><tr height="17"><td class="xl24" style="height:12.9pt;width:246pt" height="17" width="328">crayons-pack-1004)</td> </tr></table> I would like to split the...
  12. B

    Split Suburb, state and postcode into three seperate colums

    Hi I am looking for some help in how to split the follow addresses into two separate boxes. Example of current database. Lucas Heights 2234 Sylvania 2224 Barden Ridge 2234 I need Lucas Heights in one box and 2234 in another, any ideas of a macro? Regards, Rob.
  13. P

    Splitting of columns in different worksheets

    I have N no. of columns in the 1st worksheet which can be named as Master or source sheet and the requirement is to split the columns as per required into the different worksheets of the same workbook. Example: I should be able to split it like 2 or 3 columns in worksheet 2, 5 or 6 columns in...
  14. A

    splitting cells based on commas

    How do I split a series of cells based on commas? There is a series of data in 2 consecutive cells, with the data in each cell corresponding to the data in the adjacent cell. I need that each pair should be lined up in separate columns. Here is the example: I need to match up the SKU with the...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top