• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

HOw to de-concatinate

G

Gulshan Hinduja

New Member
i have a string of text (alpha-numeric). How do i split the string into pre-defined array of cells (to be predefined by a separacter).


But how to do it :)
 
Hi,


If you are doing this manually in Excel then you can use the Text to Columns tool on the Data tab of the ribbon (select the column of data > text to columns > delimited > choose your delimiter).


If you are doing this in VBA then you can use the VBA.Split() function or you can automate the Text to Columns tool (the Range.TextToColumns() method).
 
Good day Gulshan Hinduja


You may find this workbook of help.

https://dl.dropbox.com/u/34893656/Copy%20of%20Split_Cells.xlsm
 
You must log in or register to reply here.
Back
Top