Prev: Put excel data on a US mapNext: Formula Help From: John K on 7 Apr 2010 18:50 I have a cell that I want to say put in ab123456789us, but have it look like ab 123 456 789 us. Is there away to do that? From: Mike on 7 Apr 2010 19:24 Put this into cell A1 ab123456789us Maybe this. Put into cell B1 =MID(A1,1,2)& " "&MID(A1,3,3)& " "&MID(A1,6,3)& " "&MID(A1,9,3)& " "&MID(A1,12,2) "John K" wrote: > I have a cell that I want to say put in ab123456789us, but have it look like > ab 123 456 789 us. Is there away to do that? From: Gord Dibben on 7 Apr 2010 19:43 Not by formatting alone.............only true numbers will accept formatting. If only the one you could use custom format of "ab"000000000"us" Then enter 123456789 in the cell. But I'm sure ab123456789us is example only. Can you post some more examples? Might be able to work up some code for you. Gord Dibben MS Excel MVP On Wed, 7 Apr 2010 15:50:01 -0700, John K wrote: >I have a cell that I want to say put in ab123456789us, but have it look like >ab 123 456 789 us. Is there away to do that? From: ozgrid.com on 7 Apr 2010 20:59 The only way I can think of is via formulas; =LEFT(H1,2) & " " & MID(H1,3,3) & " " &MID(H1,6,3) & " " &MID(H1,9,3) & " " & RIGHT(H1,2) -- Regards Dave Hawley www.ozgrid.com "John K" wrote in message news:E11914E9-CEDE-40F3-A23B-22D44F612986(a)microsoft.com...>I have a cell that I want to say put in ab123456789us, but have it look >like > ab 123 456 789 us. Is there away to do that? From: John K on 8 Apr 2010 01:01 The thing is that the first 2 letters would change, but the us would always be the same. I know in ms access you can do it and also have auto tabbing. But in my office I'm the only one with ms access. And we're using office 2003. John K "Gord Dibben" wrote: > Not by formatting alone.............only true numbers will accept > formatting. > > If only the one you could use custom format of "ab"000000000"us" > > Then enter 123456789 in the cell. > > But I'm sure ab123456789us is example only. > > Can you post some more examples? > > Might be able to work up some code for you. > > > Gord Dibben MS Excel MVP > > > > On Wed, 7 Apr 2010 15:50:01 -0700, John K > wrote: > > >I have a cell that I want to say put in ab123456789us, but have it look like > >ab 123 456 789 us. Is there away to do that? > > . >  |  Next  |  Last Pages: 1 2 Prev: Put excel data on a US mapNext: Formula Help