1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • How to use multiple space in a word in a single cell in google sheets

    From 3020_ RABBY@21:1/5 to All on Tue Jan 31 10:45:51 2023
    Ex: given input is, "Competition"
    my output should be like this "Co mpe titio n"
    How can I do this in a single cell?

    --


    * <http://www.kiit.ac.in>*

    *
    Go Green: Kindly don't print this unless so
    required.*

    *
    *

    *Established U/S 3 of UGC Act and Accredited by NBA of  AICTE and NAAC of UGC*



    Visit us @ *http://www.kiit.ac.in
    <http://www.kiit.ac.in/>*

    Follow us @* **|***Twitter <https://www.twitter.com/KIITUniversity/>***|***Facebook** <https://www.facebook.com/KIITUniversity>*|***Instagram <https://www.instagram.com/KIITUniversity/>***|*






    The information
    contained in this electronic message and any
    attachments to this message
    are intended for the exclusive use of the
    addressee(s) and may contain
    proprietary, confidential or privileged
    information. If you are not the
    intended recipient, you should not
    disseminate, distribute or copy this
    e-mail. Please notify the sender
    immediately and delete all copies of
    this message and any attachments.


     VIRUS WARNING: Computer viruses can
    be
    transmitted via email. The recipient shoul
  • From Philip Herlihy@21:1/5 to All on Wed Feb 1 13:10:33 2023
    In article <[email protected]>, 3020_ RABBY wrote...

    Ex: given input is, "Competition"
    my output should be like this "Co mpe titio n"
    How can I do this in a single cell?

    This is an Excel group, so I'll give you an Excel answer (likely to apply in Sheets as well). You can use the MID() function to extract parts of a string, and concatenate ("&") to put them back together again, including (quoted) spaces as you wish.

    I don't understand the underlying (general) requirement, and I have to say I wonder if you do either! Why would you want to do this?

    --

    Phil, London

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)