I din celle "A1" har du en adresse og et postnummer: "Danmarksvej 1, postnummer: 1000"

Du ønsker alt tekst til venstre for teksten "postnummer" i din resultatcelle "B1".

EDIT 2013-04-13: The best way to launch fixed amounts of stock to stores is through allocations.

Funktionstasten "F11"

Du har en tabel med data og cellemarkøren er i tabellen.

Logistik er et vigtigt element i projektstyring, hvor ressourcer skal fordeles optimalt.

When you want to buy a quantity in E3 of an item in addition to your daily replenishment, you can use Plans to achieve this.

How can we handle periodic discounts from suppliers and vendors in ASR and AWR?

We have several options:

Navigation

Change tabs: Ctrl + Tab or Ctrl + Shift + Tab
 
Change sub tabs: Ctrl + page down or Ctrl + page up
 
Database Selector: F2
 

In E3 there is no simple solution to an optimal buying pattern, if you only achieve discounts if you buy in eaches of for exampel 10.

There is a way solving this problem. 

Dim EksterntRegneark As Workbook
Set EksterntRegneark = Workbooks.Open("C:\mappe\filnavn.xls", True, True) 'Kun til læsning