Microsoft Office Forums - View Single Post - [Solved] How can I break a single group of words into three sets?

Thread: [Solved] How can I break a single group of words into three sets?

View Single Post

Old

03-22-2011, 02:35 PM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

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)

__________________
Colin

RAD Excel Blog

Reply With Quote