By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 2,037 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

referencing charachter sets

P: n/a
I have a data set that looks similar to the following when cut and
pasted into excel or referenced into access:

1000:24:00
987:24:00
87:24:00
7:24:00

The only data I need is in the first four charachter spaces noted
above. I would like the values to return as follows:

1000
987
87
7

or

1000
0987
0087
0007

Please give this a try. Excel and access want to see it as a TIME
reference.

Thanks...Mike
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Left([NameOfDataField],Instr([NameOfDataField],":")-1)

Steve
PC Datasheet
"Mike" <mi********@yahoo.com> wrote in message
news:c5**************************@posting.google.c om...
I have a data set that looks similar to the following when cut and
pasted into excel or referenced into access:

1000:24:00
987:24:00
87:24:00
7:24:00

The only data I need is in the first four charachter spaces noted
above. I would like the values to return as follows:

1000
987
87
7

or

1000
0987
0087
0007

Please give this a try. Excel and access want to see it as a TIME
reference.

Thanks...Mike

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.