Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Slice up cell data
|
|
|
Bookmark this page|
The UK's most regular 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. |
Slice up cell data
Resolved · Low Priority · Version 2003
Reply
Slice up cell data
i saw a function where a colleague split out an IP range (198.160.0.1-198.160.0.5) from one cell to two cells(198.160.0.1 and 198.160.0.5.what is this function called and where can i find it?
For upcoming training course dates see: Pricing & availability
RE: Slice up cell data
Hi Richard, thanks for your query. The function is called "Text to columns" and it lives in the Data drop down menu. Your colleague set the delimiter to "-" and the computer did the rest!Hope this helps,
Anthony
|
 |
|
» Forum post: Holidays/non-working days |
How can I view non-working days on the gantt chart?
