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 » Slice up cell data
Slice up cell data
Resolved · Low Priority · Version 2003
Tue 2 Feb 2010, 16:49Delegate Richard said...
Richard has attended:
Excel Intermediate course
Excel Advanced course
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?
Wed 3 Feb 2010, 07:16Trainer Anthony said...
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
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. |
Excel tip:Using an equal (=) sign that isn't part of a formulaBefore you type the equal sign, type an apostrophe: ' |
