LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 519
Default If I use 10 macro is ok but if I use 10: Auckland City Depot i

Hello OssieMac from Steved

Thankyou very much.


"OssieMac" wrote:

Hi again,

I should have included insert your case like this and you will get a match.

Case Left("10: Auckland City Depot", 20)

--
Regards,

OssieMac


 
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
Latest Taxation Books available at jain book depot LATEST BOOKRELEASES JACK ANDERSON Excel Worksheet Functions 0 May 29th 10 01:25 PM
The formula works if I copy from Auckland Kilometres Steved Excel Worksheet Functions 4 March 12th 09 07:55 PM
city st zip cells Joanne[_4_] Excel Programming 8 September 22nd 06 03:18 PM
To include Depot Steved[_3_] Excel Programming 9 September 24th 04 03:20 AM
To include Depot Steved[_3_] Excel Programming 0 September 24th 04 02:13 AM


All times are GMT +1. The time now is 04:07 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"