Need more info: What is the format of the folder name and what is the
standard form of the user name. In other words, given that you begin looking
in a fixed position, what logic can be followed to find the end of the user
name?
--
- K Dales


"Silvertip" wrote:


Hi,

I'm a VB6 developer, but I am battling to get to grips with this. I
have a spreadsheet with two columns (A & B). In column A, is a folder
name, embedded in which is the user name and in column B, is an amount.


I need to loop for all rows, and starting in a fixed position in column
A, derive the user name and put that in column C. However, the username
is not fixed length.

Can someone PLEASE help as I have been trying for a good few hours and
not getting very far.

Thanking you!


--
Silvertip
------------------------------------------------------------------------
Silvertip's Profile: http://www.excelforum.com/member.php...o&userid=28456
View this thread: http://www.excelforum.com/showthread...hreadid=480586