Use the LEFT function in cell C10 to return the text "Shipment number " (notice the space after number) from the "Text Stamp Phrase" in cell C7. Use a reference to the location of the "#" symbol in cell C9 as the "[num_chars]" argument. Since the "#" symbol is 1 character past the text you want to return, you will need to adjust the "[num_chars]" argument by subtracting 1 from the reference to cell C9.

Excel Fle Edit Aura View Insert Format Debug Run Tools Window BE6 TextandTimeS.CO.Madison Letende Page Layout Formulas Data Review View Assignment Tell me insert Draw 1 to Tak Guide Suomi View aport Use the LEFT her number from smo the you Tube from covered workboost Your recent changes were saved. Do you want to continue working where you left? F-LEFT, Shipment number,c7) Womento diverses ved at dy TROPIC www.with componendid tot functiontece en wat werkt. Schwering wil weer ar F Lot Phrana Prime Pata TAL IMAI The winner aurat w Part Second Mitternden 20 061 3941 DO 1046 01119 17 0 1994 0 0 D8593 . 1E 1011 . 16 1 3341 . . 104 9 DO 300 02 04 Tracker Shine Le Ready Count: TO 24 . 98 DO ce ga DI TE bo a $ % A ( 1 2 3 4 & 7 5 6 8 9 0 Q W E R T Y U 0 A S DFG Excel Fle Edit Aura View Insert Format Debug Run Tools Window BE6 TextandTimeS.CO.Madison Letende Page Layout Formulas Data Review View Assignment Tell me insert Draw 1 to Tak Guide Suomi View aport Use the LEFT her number from smo the you Tube from covered workboost Your recent changes were saved. Do you want to continue working where you left? F-LEFT, Shipment number,c7) Womento diverses ved at dy TROPIC www.with componendid tot functiontece en wat werkt. Schwering wil weer ar F Lot Phrana Prime Pata TAL IMAI The winner aurat w Part Second Mitternden 20 061 3941 DO 1046 01119 17 0 1994 0 0 D8593 . 1E 1011 . 16 1 3341 . . 104 9 DO 300 02 04 Tracker Shine Le Ready Count: TO 24 . 98 DO ce ga DI TE bo a $ % A ( 1 2 3 4 & 7 5 6 8 9 0 Q W E R T Y U 0 A S DFG