Adding space to postal code in excel

[ddvuillaume]

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

 

[Pete_UK]

Well, you have missed a bracket off the end of the formula:

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

but I would have expected Excel to suggest that to you.

Hope this helps.

Pete

 

[Rick Rothstein \(MVP - VB\)]

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

 

[ddvuillaume]

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

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

 

[Barb Reinhardt]

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)

 

[Rick Rothstein \(MVP - VB\)]

NOTE: You should always follow the posting style of the message you are
answering. For whatever reason, the style of posting is to "top post"
messages on the Excel newsgroups. I placed my answer at the top of my
response to you, so you should have put your response at the top (not
bottom) of your response back to me. You would do this to make it easier for
someone reading this thread in the archives to follow. I moved your response
to the top of this message and am top posting my response to it.

The #NAME? error indicates Excel does not recognize one or both of the
function names you used. I know XL2008 for the Mac removed VBA, but, to the
best of my knowledge, it did not change the worksheet function side of
Excel, so your formula should have worked fine. You can verify this by doing
as Barb suggested and looking LEFT and RIGHT up in the help files... you
should find entries for them (proving they still exist). I do not have a
Mac, so I cannot do any testing for you. Hopefully, someone with XL2008 will
join in this thread and see if they can get you a definite answer.

Rick