Help!

[Martian262002]

Hello everyone ,

Episode Visits: SN: 4, HHA: 24/Supplies: 7

The above is my the information I need! I need the SN:4, HHA:24 & Supplies:7!
The above example is in one field, and I need the given information in a separate field!

Ex: Episode Visits: SN: 4, HHA: 24/Supplies: 7

Fields: SN, HHA, Supplies
Data: 4, 24, 7

Each person has a row of information like the example (Episode Visits: SN: 4, HHA: 24/Supplies: 7)
Ex: Mike Todd Smith, Episode Visits: SN: 4, HHA: 24/Supplies: 7
Jake the Snake, Episode Visits: SN: 4, HHA: 24/Supplies: 7
Ravishing Rick Rude, Episode Visits: SN: 4, HHA: 24/Supplies: 7
The British Bulldog, Episode Visits: SN: 4, HHA: 24/Supplies: 7
The SN, HHA, & Supplies are all separate fields!

I'm trying to think of a way to do this without coding a module!

Can anyone help me?

Thanks,

 

[KeithG]

Why don't you want to use VBA?

 

[ghudson]

You need to parse the data out. Search for the keyword "parse". The Mid() and Instr() functions will assist. I do not have any examples on how to do what you want.

Good luck!