I think I'd do a search for LEFT and RIGHT in your help. I wonder if they
aren't supported. Alternatively, you could use MID if it's supported.

MID(A1,1,3) & " " & MID(A1,len(A1)-3,3)
--
HTH,
Barb Reinhardt



" wrote:

On Aug 18, 6:13 pm, "Rick Rothstein \(MVP - VB\)"
wrote:
I'll assume the missing closing parenthesis at the end of the line you
posted is a typo; so, describe "does not work" for us... what do you have,
what did you expect to happen, what actually happened instead?

Rick

wrote in message

...

Hi there i have tried

= LEFT(A1,3) & " " & RIGHT(A1,3

and it does not work.

I have excel 2008 mac.

Is that wy?

and what can i do.

Please help its urgent

I got a name error: #NAME?
parenthesis is a typo..