Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-22-2011, 12:18 AM
Learner7 Learner7 is offline How can I break a single group of words into three sets? Windows XP How can I break a single group of words into three sets? Office 2007
Advanced Beginner
How can I break a single group of words into three sets?
 
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default How can I break a single group of words into three sets?

Hi,

How can I break the following group of words into three sets but in one Cell:

Example:

Querry:


Cell "A1" = 0558476585

Result:
Cell "B1" = 055 847 6585

Last edited by Learner7; 03-22-2011 at 03:25 AM.
Reply With Quote
  #2  
Old 03-22-2011, 02:35 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline How can I break a single group of words into three sets? Windows 7 32bit How can I break a single group of words into three sets? Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi,

Assuming all of the numbers have 10 digits, this formula will do it:
Code:
=LEFT(A1,3)&" "&MID(A1,4,3)&" "&RIGHT(A1,4)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
paragaph hard break, soft break and ...strange break czomberzdaniela Word 2 12-03-2010 06:58 PM
How can I break a single group of words into three sets? 2 sets of names and adresses. need to know which addresses have changed. (Picture) spartanhockey Excel 6 01-27-2010 01:54 PM
How can I break a single group of words into three sets? Finding the complements between the two data sets psenku Excel 2 08-17-2009 11:15 PM
How can I break a single group of words into three sets? How do I accept non-Western (non-latin) character sets 3rd floor Outlook 1 02-10-2006 03:17 PM
How can I break a single group of words into three sets? One bar chart for 3 sets of data rclloyd Excel 1 02-03-2006 09:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft