Opposite Of Concatenate


Active Member
Feb 1, 2004
Is there a function or macro that will put each field in a seperate column accross the sheet

A1= vimHOLDINGS_0.Symbol, vimHOLDINGS_0.GroupInvId, vimHOLDINGS_0.Ticker, vimHOLDINGS_0.QuantityShort, vimHOLDINGS_0.QuantityLong, vimHOLDINGS_0.Portfolio, vimHOLDINGS_0.SharesOutstanding, vimHOLDINGS_0.MarketValue, vimHOLDINGS_0.InvType, vimINVESTMENTS_0.InvDesc, vimINVESTMENTS_0.Region, vimINVESTMENTS_0.ExposureSector, vimHOLDINGS_0.Date

I want
B1 = vimHOLDINGS_0.Symbol
C1 = vimHOLDINGS_0.GroupInvId
D1 = vimHOLDINGS_0.Ticker

The cells do not have the same number for fields, they will have 1- 15 fields

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)


Well-known Member
Apr 4, 2007
You could try using data>text to columns and delimit it based on the comma. But it will split them out in the order they are in in the cell.

Its also a good practice to not start more than one thread on the exact same issue.

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...