Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

split string

Status
Not open for further replies.
99mel

99mel

Programmer
Oct 18, 1999
379
GB
Is there a function which can split a string into a certain number of characters?

i.e. split the following into segments of 2 characters.

12345678


a = 12
b = 34
c = 56
d = 78
 
Sort by date Sort by votes
you could use the mid function in a loop!

good luck!

If somethings hard to do, its not worth doing - Homer Simpson
------------------------------------------------------------------------
A General Guide To Excel in VB FAQ222-3383
File Formats Galore @
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
GET splitted value from node and sub node in treeview
Replies
1
Views
176
Andrzejek
Andrzejek
NewAccount13
  • Locked
  • Question
How to use Split function with Unicode Delimiter in Visual Basic 6
Replies
6
Views
164
strongm
strongm
sal21
  • Locked
  • Question
SPLIT BIG TXT FILE IN SMALLER OTHER FILE LINES IN A BLOCK OF 10000 ROW
Replies
10
Views
187
strongm
strongm
2009luca
  • Locked
  • Question
Write a fixed string 1
Replies
9
Views
158
strongm
strongm
drgt
  • Locked
  • Question
xlsx splitter by rows
Replies
1
Views
75
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top