Wrap a long text in a cell

[tantcu]

Hello,

I have a cell contain this for example. A1= a12345b5468accs556

Is there a way that cell A1 can display the content like this

a12345
b5468
accs556

I want all this wrap in one single cell.

Is this possible?

Thank you

[Pete_UK]

Click on that cell as if to edit it and move the cursor to between the 5 and the b, and then hold down the Alt key and press Enter, then release Alt, then move the cursor to just after the 8 and do Alt-Enter again, then just a normal Enter. If the row height does not adjust automatically, you will need to use Format Cells | Alignment tab and click against Wrap Text.

Hope this helps.

Pete

[tantcu]

Thanks for the quick reply. Imagine if there are hundred of cells like this, are there any formulars to split between the text and the number and move them down to another sentence as it is above.

[Pete_UK]

Are they all of the same format, i.e. split after the first 6 characters, and then after the next 5 ??

Post a few more examples, showing the range of values that you have, or better still, attach a workbook to your post.

Pete

[tantcu]

Yes it is the same formate

[jeffreybrown]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.