Results 1 to 8 of 8

create a vba function to split text in multiple non adjacent cells

Threaded View

  1. 12-14-2017, 06:30 AM #1
    leprince2007
    leprince2007 is offline
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    769

    create a vba function to split text in multiple non adjacent cells

    Hello everybody,
    I want to create a normal function or vba function to split text in multiple non adjacent cells.
    Expected vba function:
    split(e3,h3,k3,n3,q3)
    See the attachment
    Attached Files Attached Files
    Last edited by leprince2007; 12-14-2017 at 07:08 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to split text & numbers in one cell to multiple cells
    By MaheshK5277 in forum Excel General
    Replies: 11
    Last Post: 02-23-2016, 07:13 AM
  2. Split text entered in UserForm text box into two cells; split at space within sentence.
    By tpsmith in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-11-2015, 03:00 PM
  3. Split text in single cells to be in multiple cells
    By mason0567 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2015, 02:59 PM
  4. Split cells long text with Max 40 character to multiple row using Macro
    By chee1012 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-31-2012, 10:10 AM
  5. Combine text in multiple cells if adjacent column is blank
    By problematic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2012, 01:52 PM
  6. [SOLVED] split text in one cell into multiple cells without breaking the wo
    By Prashant in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2006, 04:48 AM
  7. [SOLVED] Searching for patterns in text split into adjacent cells
    By chemdude77 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2006, 07:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1