Hello,
i have a huge list of Booked times for a customer, and some of the booked hours correspond to a special ticket number.
The problem of the text is, that the ticketnumber is standing wherever the tester and developer mentions it.
But the certain string always starts with CC-. Is there a formula to get the string containig always combinations of thext and text like:
CC-35293-D9G5 out of it?
Stefan
Extract special Textblock from String
-
- 4StarLounger
- Posts: 415
- Joined: 29 Mar 2010, 11:50
- Location: Vienna, Austria
Extract special Textblock from String
You do not have the required permissions to view the files attached to this post.
-
- 4StarLounger
- Posts: 565
- Joined: 27 Jun 2021, 10:46
Re: Extract special Textblock from String
Something like
=MID(A18,SEARCH("CC",A18),13)
=MID(A18,SEARCH("CC",A18),13)
-
- 4StarLounger
- Posts: 415
- Joined: 29 Mar 2010, 11:50
- Location: Vienna, Austria
Re: Extract special Textblock from String
thank you, cool.
-
- 5StarLounger
- Posts: 605
- Joined: 18 Jan 2022, 15:59
- Location: Re-routing rivers, in Hof, Beautiful Bavaria
Re: Extract special Textblock from String
Hi
Just a quick heads up: I think the formula will error on those cells not containing CC. (In the uploaded file some cells don’t contain a CC) I don't know if that is of concern?, - so just mentioning it in case.
Alan
Just a quick heads up: I think the formula will error on those cells not containing CC. (In the uploaded file some cells don’t contain a CC) I don't know if that is of concern?, - so just mentioning it in case.
Alan
You do not have the required permissions to view the files attached to this post.
Last edited by DocAElstein on 09 Apr 2024, 21:46, edited 1 time in total.
I seriously don’t ever try to annoy. Maybe I am just the kid that missed being told about the King’s new magic suit, :(
-
- 4StarLounger
- Posts: 588
- Joined: 14 Nov 2012, 16:06
Re: Extract special Textblock from String
Code: Select all
Sub M_snb()
columns(1).replace "*CC-","CC-"
columns(1).replace " *",""
End Sub
-
- 4StarLounger
- Posts: 415
- Joined: 29 Mar 2010, 11:50
- Location: Vienna, Austria
Re: Extract special Textblock from String
cool thanks