Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Any fast method to parse a string into row & col information

Hi,

Given a string "AC19", any method to split the string into "AC" and
"19", without using string methods?

Thx

Nick
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 131
Default Any fast method to parse a string into row & col information

Hard to do anything to a string without using string
methods! (I assume you mean functions).

-----Original Message-----
Hi,

Given a string "AC19", any method to split the string

into "AC" and
"19", without using string methods?

Thx

Nick
.

  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Any fast method to parse a string into row & col information

What about the LEFT() and RIGHT() functions? They take a
string expression and get a certain number of charaters
from the left or the right.



-----Original Message-----
Hi,

Given a string "AC19", any method to split the string

into "AC" and
"19", without using string methods?

Thx

Nick
.

Reply
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
Need really fast method to sort data for my part numbering spread Chris Dundorf Excel Discussion (Misc queries) 7 March 24th 10 06:05 PM
Parse A String into Two xlmate Excel Worksheet Functions 11 February 21st 09 04:06 AM
Parse this string David Excel Discussion (Misc queries) 2 February 20th 07 04:57 AM
Q: parse string JIM.H. Excel Discussion (Misc queries) 3 October 22nd 05 01:45 AM
String Parse J Excel Programming 3 August 10th 04 10:27 PM


All times are GMT +1. The time now is 03:43 AM.

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"