98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Paste address block into an excel cell
Paste address block into an excel cell
Resolved · High Priority · Version 2010
Wed 14 Sep 2011, 16:13Delegate Philippa said...
Philippa has attended:
Project Intermediate course
Excel Intermediate course
PowerPoint Intermediate Advanced course
Outlook Advanced course
Word Advanced course
Paste address block into an excel cell
How do I paste an address into one excel cell without it spreading to a new cell at every new line?
Thu 15 Sep 2011, 11:30Trainer Rodney said...
RE: Paste address block into an excel cell
Hello Philippa,
Thank you for your question regarding containing your text within the cell.
There are a few things you can do to keep text from spilling over the next cells. They are:
1) Widen the column where the text has been placed
2) Word wrap the text which then maintains the column width but increases the row height. Select the cell with the text then from the Home ribbon click the Wrap Text button which is located on the Alignment group.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Thu 15 Sep 2011, 11:34Delegate Philippa said...
RE: Paste address block into an excel cell
Unfortunately, this doesn't help. Each line of the address goes in to a new cell. I want them all in one cell. Any other ideas? Thanks
Thu 15 Sep 2011, 11:52Trainer Rodney said...
RE: Paste address block into an excel cell
Hello Philippa,
To place text on separate lines in one cell, enter the first line of text then press ALT + ENTER. This goes to the next line and also wraps the text but does so specifically at positions that you require using ALT + ENTER
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Fri 16 Sep 2011, 13:07Delegate Philippa said...
RE: Paste address block into an excel cell
No - I am trying to paste text not enter it afresh.
Mon 19 Sep 2011, 19:49Trainer Rodney said...
RE: Paste address block into an excel cell
Hello Philippa,
Where are you copying the text from? If the address block contains many lines then it is quite obvious that when you paste the data into Excel it will appear on different rows - one row for each line of data. Excel has no way to know that you wish to paste the data into one cell... which of course is not possible.
If you require the data to be in one cell then it should be on one line in the address block, otherwise you will have to create formulas in Excel that concatenate data from 3 cells into one cell, then word wrap the resulting cell. This is an awful lot of work and I would seriously find another way to present this data in Excel. I would put each line of the adress into a separate column. This makes it easier for sorting, filtering etc.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Mon 26 Sep 2011: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
