How can I break a single group of words into three sets?

Learner7 · #1 03-22-2011, 12:18 AM

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

Colin Legg · #2 03-22-2011, 02:35 PM

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)

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
2 sets of names and adresses. need to know which addresses have changed. (Picture)	spartanhockey	Excel	6	01-27-2010 01:54 PM
Finding the complements between the two data sets	psenku	Excel	2	08-17-2009 11:15 PM
How do I accept non-Western (non-latin) character sets	3rd floor	Outlook	1	02-10-2006 03:17 PM
One bar chart for 3 sets of data	rclloyd	Excel	1	02-03-2006 09:51 AM