Results 1 to 10 of 10

Automatically punctuate a formula that lists text with commas and, fullstop.

Threaded View

  1. #1
    Registered User
    Join Date
    08-04-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    10

    Automatically punctuate a formula that lists text with commas and, fullstop.

    I was very kindly helped with some formulas a few weeks ago to help me query a summary spreadsheet, I didn't finish the job then, but am trying to now. What I am trying to do is create a written report with the data coming from summary sheet queries. This will help me reduce user error cutting and pasting data.

    What I would like to do is for the formula in k20 to return the text from each cell with a comma between each except for the last for which I would like an "and" before and a full stop after. That is make the text grammatically correct. So instead of k20 reading:

    Test had a definite difference more than others for C. Vestibular Processing and E. Multisensory Processing and F. Oral Sensory Processing.

    I would like it to read:

    Test had a definite difference more than others for C. Vestibular Processing, E. Multisensory Processing and F. Oral Sensory Processing.

    Is this possible?
    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. [SOLVED] Formula to find fullstop and remove all before it
    By ScabbyDog in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-20-2013, 10:30 AM
  2. Replies: 0
    Last Post: 09-17-2012, 11:56 AM
  3. How to find a fullstop or an exclamation mark in a string!
    By pablowilks in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-27-2012, 01:19 PM
  4. Value on worksheet with fullstop either side
    By FIRSTROUNDKO via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2006, 08:25 AM
  5. [SOLVED] How to add commas to the result of a formula with a text operator?
    By jlrichman in forum Excel General
    Replies: 2
    Last Post: 06-14-2005, 11: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