+ Reply to Thread
Results 1 to 5 of 5

a problem in text functions

  1. #1
    Registered User
    Join Date
    09-08-2014
    Location
    iran
    MS-Off Ver
    2013
    Posts
    32

    a problem in text functions

    Hi everyone
    in my excel file, in cell A1, I wrote this text: (there is a space between each word)
    Vlookup Index Offset Match
    I want to separate each word in cells B1:F1 with an array formula
    How?
    Thanks

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,734

    Re: a problem in text functions

    Why do you feel that it should be an array formula?

    Pete

  3. #3
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: a problem in text functions

    Using your example, this regular formula copied across to the right, parses the A1 text into individual words per cell
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  4. #4
    Registered User
    Join Date
    09-08-2014
    Location
    iran
    MS-Off Ver
    2013
    Posts
    32

    Re: a problem in text functions

    because I feel that I can't write a normal formula with drag it to adjacent cells.
    can you write it without array formula?

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,734

    Re: a problem in text functions

    Ron has already supplied you with one.

    Pete

+ 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. Problem with text functions
    By mastahdaer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-13-2014, 09:37 AM
  2. Replies: 1
    Last Post: 02-25-2013, 04:25 PM
  3. [SOLVED] Removing text from scores in a data sheet using text functions
    By mrvp in forum Excel General
    Replies: 9
    Last Post: 07-15-2012, 05:33 PM
  4. Problem with Min and Max functions
    By curiousexcel in forum Excel General
    Replies: 3
    Last Post: 10-19-2008, 09:38 PM
  5. Problem using VBA functions....
    By Richard Latter in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 02-28-2005, 03:06 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