LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cdn Postal Code Christine Excel Discussion (Misc queries) 3 January 16th 08 06:01 PM
Canadian Postal Code format? Fritz Excel Worksheet Functions 9 July 23rd 07 09:57 PM
Do not convert 24hr time in Excel to Portugese postal code Art Welch Excel Discussion (Misc queries) 0 August 28th 06 05:10 PM
How do I retain a zero as the first number in a postal code? Laureen Excel Discussion (Misc queries) 7 February 28th 06 05:34 PM
Validation of Postal Code Veronika Excel Worksheet Functions 1 December 16th 05 09:42 PM


All times are GMT +1. The time now is 09:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"