Thread: Adding space to postal code in excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] ddvuillaume@gmail.com is offline
external usenet poster
  
Posts: 2
Default 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
Reply With QuoteReply With Quote