go to text to column while selecting delimeter as other press ctrl+J to split your data and next and then finish.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!
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, mr.a...@gmail.com 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" <lomb...@gmail.com> wrote in message news:327d43bc-5365-4bd8...@g1g2000pra.googlegroups.com...
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
| Sysop: | Keyop |
|---|---|
| Location: | Huddersfield, West Yorkshire, UK |
| Users: | 546 |
| Nodes: | 16 (2 / 14) |
| Uptime: | 145:44:24 |
| Calls: | 10,383 |
| Calls today: | 8 |
| Files: | 14,054 |
| D/L today: |
2 files (1,861K bytes) |
| Messages: | 6,417,685 |