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

		Microsoft Office Forums > Microsoft Excel > Excel
How can I break a single group of words into three sets?

03-22-2011, 02:35 PM

Colin Legg Colin Legg is offline

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

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:56 AM.