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

In article <e600b7b5-00e2-46f2-8841-2b5d6d3e78dcn@googlegroups.com>, 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)