+ Reply to Thread
Results 1 to 2 of 2

Add Enter to a text from an array

  1. #1
    Forum Contributor
    Join Date
    07-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    476

    Add Enter to a text from an array

    Hi So this might be a little confusing, but I'm trying to add an enter space to text with the combination of a loop and an array, but I cannot find the right combination so that the final result appears as so:

    ArrayItem
    Desired Text

    or via excel
    =NamedRange&"
    Desired Text"

    Here is the code for the loop, trying to add the appendage to the first item after the if. All help truly appreciated

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    07-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    476

    Re: Add Enter to a text from an array

    Got it, took forever, but finally got it

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. With VBA Enter Ctrl Shift Enter For Array Formula
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-17-2013, 09:02 AM
  2. Enter text in same cell using alt+enter
    By vijanand1279 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-27-2013, 11:16 AM
  3. Replies: 2
    Last Post: 02-23-2011, 07:24 AM
  4. Replies: 3
    Last Post: 08-06-2009, 04:27 AM
  5. [SOLVED] enter a product numbinfo in cel needs to propt other cels to automatically enter text
    By Bill W in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-03-2005, 09:05 AM

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