Anyone know anything about excel? I have a question

[TheSiege]

I want to take data in 1 cell and have it change the value in another cell
i.e.

The user input cell would say "11-Bus-2-2A1" I want it to change the data in other cells to read
The text in quotes being what changes based on that input above

Stamp: "11"
Row: "2"
Side: "West"
Feed: "Utility"
Source: "A"

Each of the output cells need to read certain areas of the input cell to change its value
i.e. A1 = Utility
The first "2" equals row
the second "2" equals east or west depending if it is 1 or 2 and so on

Any suggestions?

 

[edro]

You need to use the "Text to Columns" tool in the Data menu.
You can easily do what you need.

Select Text to Columns in the Data tab.
Choose Delimited.
Select the Other box and type "-" in. Click Next.
Change the Destination to a different range, otherwise it will overwrite your source cell.

If you want it to auto-update, you will have to create a macro button that runs that function when you press it.

As for the 1 and 2 equaling a different word, you will need to use a lookup table. (check out VLOOKUP and HLOOKUP functions)

 

[sweenish]

I use index and match instead of the *lookup commands. Much more versatile.

I would recommend having at least one macro, assuming you know some VBA.

That user input will need some serious sanitation to make sure it can be correctly read by everything else in sheet/book.

 

[Binky]

If the text is always the same length, you can use the right, left, and mid functions.

i.e. if your data is in cell A1, the following entered into cells A2 through A6 will produce your sample results:

=LEFT(A1,2)
=MID($A$1,LEN(A1)-4,1)
=CHOOSE(MID($A$1,LEN($A$1)-2,1),"East","West")
=IF(MID($A$1,LEN($A$1)-1,2)="A1","Utility","Not utility?")
=MID($A$1,LEN($A$1)-1,1)