Prev: Put excel data on a US map
Next: 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 <JohnK(a)discussions.microsoft.com>
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" <JohnK(a)discussions.microsoft.com> 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 <JohnK(a)discussions.microsoft.com>
> 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 map
Next: Formula Help