Adding space to postal code in excel
 

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

Adding space to postal code in excel
 

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

On Aug 19, 1:43*am, wrote:
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

Adding space to postal code in excel
 

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

Adding space to postal code in excel
 

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..

Adding space to postal code in excel
 

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..

Adding space to postal code in excel
 

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


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

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