Splitting rows in a worksheet

T

Taryn

How can I split one cell in excel 2000 three ways, horizontally, to where I
have a name, then an email address and finally a phone number? Perhaps this
is not possible to do.
Please advise
 
R

Rick Rothstein

What character(s) do you have between the name and email address and between
the email address and phone number?
 
D

Dave Peterson

First, don't do it. It'll make it much more difficult if you decide to create a
mailmerge using MSWord--or sort or filter or...

But you can force a new line within a cell by using hitting alt-enter where you
want the text to wrap. You may have to widen the column to make it look nice.

If I had to do this, I'd still put my info into separate columns of the same
row, but then use a formula to concatenate those values. (And hide the
individual field columns if I had to.)

I'd use a formula like:
=a1&char(10)&b1&char(10)&c1
and format the cell to wraptext

=char(10) is the equivalent of alt-enter.
 
M

MyVeryOwnSelf

How can I split one cell in excel 2000 three ways, horizontally, to
where I have a name, then an email address and finally a phone number?
Click to expand...

One way is to select a column of such cells and use
Data > Text to columns

For detailed instructions after the Text to columns "wizard" starts, click
its <?> button for Excel's built-in Help.
 
D

Dave Peterson

Ignore my response.

I read it that you wanted to put all your address information into one cell.
 
T

Taryn

Hi Rick,
The character I was thinking about using is this |, that is on the backslash
key.
 
T

Taryn

Thanks Dave!

However, the more I think of what I am trying to do and then explain it in
the discussion, well, let me start over. In the cell, I am trying to
accomplish following:

First Lastname Taryn Johnson
[email protected] [email protected]
phonenumber 1234567890

Now when I used Alt-enter, all I have are three text lines that works as
one. I'd like to have the email formatted so that all I have to do is click
and the link puts me into my mail application. I also want to treat each
line in the cell as a seperate entity from all three lines, but the more I
think about this, my goal might best be accomplished in word, and embed the
word doc into excel. My excel spreadsheet will have other data I am working
with, inwhich word has it's limitations.

Any advice will be appreciated.
 
T

Taryn

Thanks Rick,
But please read my reply to Dave, inwhich I have re stated my question.
 
R

Rick Rothstein

Can you please elaborate... I'm not entirely sure what you are looking for
when you say...

"I also want to treat each line in the cell as a separate entity from all
three lines"...

--
Rick (MVP - Excel)


Taryn said:
Thanks Dave!

However, the more I think of what I am trying to do and then explain it in
the discussion, well, let me start over. In the cell, I am trying to
accomplish following:

First Lastname Taryn Johnson
[email protected] [email protected]
phonenumber 1234567890

Now when I used Alt-enter, all I have are three text lines that works as
one. I'd like to have the email formatted so that all I have to do is
click
and the link puts me into my mail application. I also want to treat each
line in the cell as a seperate entity from all three lines, but the more I
think about this, my goal might best be accomplished in word, and embed
the
word doc into excel. My excel spreadsheet will have other data I am
working
with, inwhich word has it's limitations.

Any advice will be appreciated.
Click to expand...
 
D

Dave Peterson

First, I still wouldn't put all that information into a single cell.

I'd use multiple cells in the same row.

Then you could have the email address as a hyperlink and just click that to
start your default email client.

If you already have the data entered and you really used alt-enter to separate
lines within the cell, you can split the lines into separate cells using:

Select the column
Data|text to columns
Delimited by other and type:
ctrl-j (hold the control key while you hit the j key)
and finish up the wizard.

Then (if all your data was nice), you'd have a separate column dedicated to the
email address.

Insert a column near that and use:
=hyperlink("mailto:" & x1, "Click me")
(change x1 to the address of the cell with the email address.)

And copy down as far as you need.
Thanks Dave!

However, the more I think of what I am trying to do and then explain it in
the discussion, well, let me start over. In the cell, I am trying to
accomplish following:

First Lastname Taryn Johnson
[email protected] [email protected]
phonenumber 1234567890

Now when I used Alt-enter, all I have are three text lines that works as
one. I'd like to have the email formatted so that all I have to do is click
and the link puts me into my mail application. I also want to treat each
line in the cell as a seperate entity from all three lines, but the more I
think about this, my goal might best be accomplished in word, and embed the
word doc into excel. My excel spreadsheet will have other data I am working
with, inwhich word has it's limitations.

Any advice will be appreciated.
Click to expand...
 
T

Taryn

Hi Rick,

Actually Dave answered my question and gave me a few suggestions I will try.
thanks again for your replies to my question.
 
Top