Function to take text from x:th char to next n char

**Temporary-Failure** · 10-06-2013, 06:16 AM

Following text is in cell:
e:\Copies O - V\Files\Company\ex-supplier\exhausts\Audi\A3 8L 96-5, 03\041-HR_Simons_Exhaust_Audi_A3_8L_rostfritt_stainless.jpg

I want function which takes text out from x:th char to next x:th char. Ie: =takeout(7;"\";8)
Function finds 7th "\" and takes text between seventh "\" and 8ht "\". Result would be: A3 8L 96-5, 03.
=takeout(6;"\";8) -> Audi\A3 8L 96-5, 03
I have tried to find solution all morning but I don't get it. I'm quite bad with DIY functions.

**martindwilson** · 10-06-2013, 06:41 AM

something like this?

**jindon** · 10-06-2013, 07:20 AM

Use in cell like

=TakeOut(A1,"\",7,8)
where
A1 holds the data
"\" = delimiter
7 = first position
8 = last position

To a standard module

Please Login or Register  to view this content.

**Temporary-Failure** · 10-07-2013, 02:19 AM

Thanks Jindon. Perfect.

Function to take text from x:th char to next n char

LinkBack

Thread Tools

Rate This Thread

Display

Function to take text from x:th char to next n char

Re: Function to take text from x:th char to next n char

Re: Function to take text from x:th char to next n char

Re: Function to take text from x:th char to next n char

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Char (10) function not working

Changing a single Char in a string to another ASCII char

[SOLVED] Tab char in text data

8500 cells with phone number(7 char.), wishing to add area code (10 char.)

[SOLVED] How can I use CHAR() function in VB?

Bookmarks

Bookmarks

Posting Permissions