On Wednesday, June 10, 2015 at 7:33:02 AM UTC-4, Mandeep Baluja wrote:
go to text to column while selecting delimeter as other press ctrl+J to split your data and next and then finish.
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/ https://www.linkedin.com/profile/view?id=312532939
On Wednesday, June 10, 2015 at 1:20:43 PM UTC+5:30, [email protected] wrote:
This was really helpful and i interested in knowing how did we figure out CTRL+J as the key to use ??
On Tuesday, July 28, 2009 at 9:25:15 PM UTC+5:30, RagDyeR wrote:
Don't exactly know what you mean by a "paragraph mark",
but if you used Char(10) (<Alt> <Enter),
try this is TTC:
Use "Delimited" and in the second step of the wizard,
click on "other" and enter
<Ctrl> <J>
(Of course, you realize that nothing will be visible in the box.)
Then <Finish>
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit! =====================================================
"AL" <[email protected]> wrote in message news:[email protected]...
Hi all --
I have an Excel sheet where one column has entries on two lines in the single cell (separated by a paragraph mark). I want to split the
column into two using the paragraph mark as the delimiter -- but I haven't been able to do this successfully. Is it possible and, if so, how do I go about it?
Many thanks,
AL
Thank you! this helped me today! At first it didnt work, but I think you have to put a space in, and then Control J, and then it worked!
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)