I want to extract 1 word/number from a cell

Senji · May 8th, 2002, 08:44 AM

Cell B10 could say:

Tank 1a after discharge
Tank 1a after circulation
Tank 1a Sample and Analysis

but it always starts off as Tank xx

I have a macro right now that saves the files to various directories based on that information. I would like to make it save another file based on what tank is listed in that cell. How can I get that info from that cell?

Thanks!

Zac

kkknie · May 8th, 2002, 09:13 AM

Assuming the first 7 characters are always Tank xx, you can use the Left function:

Left("A1",7)

K

Senji · May 8th, 2002, 09:23 AM

Our tank numbers vary from 1 character to 5 usually...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 08:44 AM	#1
Senji New Member Join Date: Mar 2002 Posts: 32	Cell B10 could say: Tank 1a after discharge Tank 1a after circulation Tank 1a Sample and Analysis but it always starts off as Tank xx I have a macro right now that saves the files to various directories based on that information. I would like to make it save another file based on what tank is listed in that cell. How can I get that info from that cell? Thanks! Zac

May 8th, 2002, 09:13 AM	#2
kkknie Board Regular Join Date: Apr 2002 Location: Greenwood, SC Posts: 677	Assuming the first 7 characters are always Tank xx, you can use the Left function: Left("A1",7) K

May 8th, 2002, 09:23 AM	#3
Senji New Member Join Date: Mar 2002 Posts: 32	Our tank numbers vary from 1 character to 5 usually...