Y
yakalo
I have a large word document that is a directory of contact information - I
have replaced all the Name: / Phone: / Email: / Fax: / Website: text with " &
" and am using that as my delimiter symbol, so I thought I could just import
it and have each piece of information go into it's own column.
The problem is that I have no way of telling excel when to start a new row
with the information that I'm importing - essentially I want it to start a
new row every, say, five 'pieces of information,' so that I have name / phone
/ email / fax / website columns, and a long list of names, phone #'s, email
addresses, etc. under each heading. Right now it is just running all the
information together, so that my columns go name / phone / email / fax /
website / name / phone / email / fax / website /name / phone / email / fax /
website /name ... etc., and then carry over onto the next row once it runs
out of room.
Does anyone have any suggestions or ideas for how I can specify a new row?
Hopefully this makes sense - let me know if you need clarification at all.
Thanks in advance for your help!
SP
have replaced all the Name: / Phone: / Email: / Fax: / Website: text with " &
" and am using that as my delimiter symbol, so I thought I could just import
it and have each piece of information go into it's own column.
The problem is that I have no way of telling excel when to start a new row
with the information that I'm importing - essentially I want it to start a
new row every, say, five 'pieces of information,' so that I have name / phone
/ email / fax / website columns, and a long list of names, phone #'s, email
addresses, etc. under each heading. Right now it is just running all the
information together, so that my columns go name / phone / email / fax /
website / name / phone / email / fax / website /name / phone / email / fax /
website /name ... etc., and then carry over onto the next row once it runs
out of room.
Does anyone have any suggestions or ideas for how I can specify a new row?
Hopefully this makes sense - let me know if you need clarification at all.
Thanks in advance for your help!
SP