Results 1 to 5 of 5

Insert column with text parts from two cells

Threaded View

CoSinus Insert column with text parts... 05-26-2020, 05:14 AM
Paul Re: Insert column with text... 05-26-2020, 03:03 PM
CoSinus Re: Insert column with text... 05-27-2020, 07:51 AM
Paul Re: Insert column with text... 05-27-2020, 12:51 PM
CoSinus Re: Insert column with text... 05-29-2020, 08:26 AM
  1. #1
    Forum Contributor
    Join Date
    05-24-2020
    Location
    London
    MS-Off Ver
    Office 365 pro
    Posts
    177

    Insert column with text parts from two cells

    Hello, everyone,
    I would like to insert a help column to the right of column A.

    Fox.png

    This column should take over the cell contents of A and also the contents of column C, unless it is a pure number.
    A number that is combined with text or characters does not count and can be used (row 4)

    There should be a hyphen between the text from A and the text from B.

    In the attached picture you can see the compound inserted column B.
    If column C is empty, then the macro should go to the next (D) and take the word or word/character combination and insert it after the hyphen (example row 12).
    If column D is also empty, then the macro should find the next described column and if there it takes the word or word-character combination, and so on. (row 20)

    If the column C or the next described column contains a pure number and no letter, then nothing should happen (row 19).

    I have a formula that can do this but I would like a code.

    =TEXTJOIN("-",TRUE,A1,IFERROR(INDEX(C1:K1,MATCH(1,ISTEXT(C1:K1)*(C1:K1<>""),0)),""))
    Thanks very much in advance for your help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Insert text in whole calendar column (day) using Information from other cells
    By joelmoor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2019, 11:12 AM
  2. Insert spaces into specific parts of text string
    By southpaw5271 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-12-2016, 11:13 AM
  3. VBA to insert and merge cells until all text in column is visible
    By teaker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2016, 02:13 PM
  4. Insert Rows in between cells of text in different column
    By king10001 in forum Excel General
    Replies: 2
    Last Post: 05-26-2015, 11:46 AM
  5. Replies: 0
    Last Post: 02-09-2011, 07:13 PM
  6. How do I insert cells at certain parts of rows
    By tweacle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2007, 03:06 PM
  7. How do I strip out some parts of a column of text data?
    By footballcmr2 in forum Excel General
    Replies: 3
    Last Post: 07-01-2005, 03:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1