Adding space to postal code in excel

  • Thread starter Thread starter ddvuillaume
  • Start date Start date
D

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
 
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
 
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
 
Back
Top