Finding Text Within A Longer String

May 21, 2008

i need help with 2 formulas to return text within a longer string.

the first result i need is a style #. this will always start at the 5th character, but the length is variable. it will always end right before the last "/" or "" in the string (there may or may not be a / or within the style number)

the 2nd result i need is a description of the style. this will always be after the last "/" or "" in the string and end before a ".", but there may not always be a period in the string.

Text string: ABC123123BASIC TEE.black
Style # result: 123123
Description result: BASIC TEE

Text string: DEF/4567LEAH/FLORAL TANK DRESS
Style # result: 4567LEAH
Description result: FLORAL TANK DRESS

ADVERTISEMENT

Search Cell For Text String And Paste Text In Based On Finding?

Jun 29, 2014

I need to create a macro to do the following:

Search the activecell for a text string (a), and then either paste in text string (b) at the end of the cell if (a) is found, or text string (c) if (a) is not found.

For example, if the activecell has "AA/" in it, I want the cell to become "AA/01" (pasting in "01" at the end), and if the cell has just "AA" in it, I want it to still become "AA/01" (pasting "/01" at the end). The macro will be linked to a commandbutton.

View 7 Replies View Related

Finding Text Within A String

Oct 24, 2008

On my spreadsheet I have a column entitled: "Item Title", and the data within this column can look like the following;

View 3 Replies View Related

Finding Numbers In Text String

May 11, 2010

In a data report i have a column which contains a mix of text and may contain an 8 digit number which could start in 0.

for example

in column A i could have "Hello how are you 01237232 I am fine"

I wish to extract the number into a seperate column, and would ordinarilly use a mid or left/ right function, however the text infront and behind the number will vary in length, which means i cannot do this.

The number will always be 8 digits, could start in 0 but will not always, and it may not be present in all the cells in this column.

How I an achieve this?

View 11 Replies View Related

Finding A Number Within A Text String

Oct 28, 2007

I want to find a number within a text string, then count the letters in the same string, then add the number to the number of letters.

For example, if I have 9RR in a cell, I want to add 9 + 2 = 11.

The data will always be arranged with the number on the left side of the string.

So, if the number is a single digit, I know I can use left(A1) + len(A1) -1 to get my desired result. But, the trouble I am having is what if there is a double digit number like 10RR...I'm not quite sure how to create a formula (without using VBA) to give me a result of 12 for this cell.

View 9 Replies View Related

Finding Text String & Format

Apr 10, 2008

I have a mass of text in a cell. I would ideally like to search the text to format in a different font colour so it can be easily seen where the specific text is.

My current way is to use SEARCH in conditional formatting but this changes the whole cell not the specific text I am interested in.

EG. - I interested in the text PETER in my cell so would like PETER to be in red font.

A peck of pickled peppers Peter Piper picked; If Peter Piper picked a peck of pickled peppers, Where's the peck of pickled peppers Peter Piper picked?

View 10 Replies View Related

VBA - Fill Until String Longer Than 10

May 23, 2012

this is a hard nut I've been working on for a while. I have a worksheet that in column A has the following rows:

| A
1 | 21432 - Accessories
2 | SortPrice
3 | 1
4 | 2
5 | 3
6 | 4
7 | 5
8 | 6
9 | 21440 - Furniture
10| SortPrice
11| 1
12| 2
and so on...

What I'm trying to do, is to make a macro that will fill the value "21432 - Accessories" down until the next which is "21440 - Furniture", which then should be filled down until the next 5 digit value..

In my opinion the best way to approach it would be to search for a string longer than say 10 characters, then fill it down until the next string that's longer than 10 characters..

This is what I'd like it to look like after the macro has been run:
| A
1 | 21432 - Accessories
2 | 21432 - Accessories
3 | 21432 - Accessories
4 | 21432 - Accessories
5 | 21432 - Accessories
6 | 21432 - Accessories
7 | 21432 - Accessories
8 | 21432 - Accessories
9 | 21440 - Furniture
10| 21440 - Furniture
11| 21440 - Furniture
12| 21440 - Furniture
and so on...

View 3 Replies View Related

Finding Specific Text Within String Of Text?

May 12, 2014

I have a report that in column BX has a large string of text (html information). Within this text there is a phrase called "| Hear = Education Website |" The phrase Education Website can be a variety of things though (Up to 9 choices). What is a formula I could use to just pull out the text after "Hear =" but before |""?

View 8 Replies View Related

Finding Nth Position Of Character Within Text String

Jun 16, 2012

Title should read: Finding the nth Occurrence of a character within a text string

I have a very long text string that is delimited by about 50 "/" to segment certain values within the text string. I want to be able to extract the text between the 33rd and 34th occurrence of "/". How to do this?

View 5 Replies View Related

VBA Function For Finding A Character In A Text String

Mar 12, 2008

Is there a function in VBA that is similar to either the FIND function or SEARCH function in Excel? The arguments for the FIND function in Excel are FIND(find_text, within_text, [position]).

I have a text string in VBA ("$A1:$D$13") that I want to be able to identify the first "$" and then later the ":". I'm getting tripped up on the 3rd line of code. Thanks a million.


Sub page_set_print_area()
ActiveSheet.PageSetup.PrintArea = "$A$1:$D$13"
x = ActiveSheet.PageSetup.PrintArea
Position$ = Search("$", x, 0)
End Sub

View 9 Replies View Related

Finding Text That Matches Format Criteria In String?

Oct 3, 2011

I'm trying to restructure a list of files at work into a format that makes some sort of sense and can be filtered into useful information.

Part of what I need to do, is match up all the drawing numbers that a certain project references. The numbers are formatted like "####A##" ex. 1234A01,1234A02,5678A01, etc. The cells that I need to extract drawing numbers from contain some description or other text (not just the drawing number) so I need to extract the drawing number from that cells value. (Ex. I need to get the drawing number 1234A01 from a cell whose value is "blah blah 1234A01 blah blah blah")

I was thinking I could just search the string for "####A##" but I'm not really sure how....I tried instr, but I think its searching for the literal value of "####A##" rather than treating the # characters as wildcards...

I tried:

Code:
if rngNames.Cells(intx, 2).Value Like ("*####A##*") then
set intStart = instr(1,rngnames.Cells(intx,2).value,"####A##")
'....
end if
but intStart remains 0, so this method is not working...

View 3 Replies View Related

Text Longer Than A Column

Apr 17, 2009

I just reinstalled windows (XP) and Office 2003, SP3.
When entering text in a column and if it was larger than the current column, it used to just display into the next column unless there was data in that column.

Now, it just displays a few letter from the end of the first word. How can I change this back as default?

View 4 Replies View Related

Text Can Be No Longer Than 80 Characters

Mar 17, 2014

I am submitting a book CSV file to my website. However, the website will not accept any cell that contains more than 80 characters. The error states the following. "WARNING: Title should be less than or equal to 80 chars; your Title was truncated to 80 chars" repeated 13 times.

View 2 Replies View Related

Longer Text Entry Turns Into ####..

Nov 26, 2008

I have a form in Excel that has comments fields. Each comments field is a merged cell consisting of four rows and four columns. My understanding is that Excel should be able to display 1024 characters. The input that's causing me trouble has 360 characters. At around 300 characters, the text box gets filled with ############################# instead of text.

If I size the font down significantly to where there would be absolutely no question that the text would fit, it is still #######. I may have to end up using text boxes, but they are a bit troublesome for the less Excel-savvy users of the form.

View 4 Replies View Related

Finding The Frequency Of A String In Other String(s)

Dec 8, 2009

I'm looking for a formula that will count specific word in a cell.

Let say cell a1 has "WLLWWLLLLLLWWLLLWWWLLLWWLLWWLWLWLWLLLWWW"
I want to know how many WWLL are in this cell, which is 4.

I wrote this custom function to provide the answer. It is used like so: ..

View 13 Replies View Related

Finding One String Within Another

Mar 13, 2013

I have this formula on my worksheet to test if column A="-" or "+"

Code:
=IF(OR(A:A="+",A:A="-"),NA(),"")

I would like to enhance this so that the test looks for the the + or - inside column A which might be a whole string rather than just one character and returns the same result (an NA# error if found).

I am doing this so I can then use SpecialCells to clear the cells containing the + or -

View 1 Replies View Related

Finding String In Array

Aug 8, 2013

I have list of strings to be searched in column A2 to A150 (A1 has column title). The array that needs to be searched is in B2 to AG1000 (B1 to AG1 has column title). I want each string in column A to be searched in the full array. If match is found the corresponding column title (B1 or C1 and so.) and cell address needs to written to a new result columns in AY and AZ. it should work for duplicates as well i.e. the string can be in all the columns of array from B to AG. and all of them needs to be written to result column.

View 9 Replies View Related

Finding The First Number In A String?

Jul 31, 2014

I'm trying to extract the number portion from the following string. I'm trying to use FIND to find the first digit between 1 and 2 so I used an "or" argument along with the code number, however it's not working here. What I really want to do is find any digit between 1 and 9 in the string, however I started with this formula for now. why this doesn't work and provide a better formula. I want to understand why this didn't work to understand the functions better. Text string is as follows "standard VAT rate: 20% (Jan 1984)". The formula I used in the following =MID(A253,FIND(OR(Char(49),CHAR(50)),A253),2) where A253 contains the string. Is it possible to use a logical argument within a find?

View 7 Replies View Related

Finding The Last Space In A String

Nov 17, 2006

there is AT() which finds the first occurrence of a string searching from the left like FIND() and SEARCH(), and RAT() which finds the first occurrence searching from the right-to-left.

A single column with names:
John Doe
Jane Marie Smith
Dr. Alex R. Jones
Bill

I need two columns that would look like:
John.................Doe
Jane Marie........Smith
Dr. Alex R.........Jones
Bill

View 9 Replies View Related

Finding Numbers From String

Aug 11, 2009

I am trying to find numbers from a string. I have for example words "EUR Fwd 9x12" and "Eur Fwd 11x15" And i want to write a function that reads the first number from a string if there is only one number before "x" or two numbers if there are 2 numbers. So I have tried to build following function:

Function NumbersInString(Word As String) As Integer
Dim i As Integer
Dim FirstNumberInString As Integer, SecondNumberInString As Integer
For i = 1 To Len(Word)
If IsNumeric(Mid(Word, i, 1)) Then
FirstNumberInString = Mid(Word, i, 1)
If IsNumeric(Mid(Word, i + 1, 1)) = False Then
Exit Function
Else
SecondNumberInString = Mid(Word, i + 1, 1)
End If
End If

Next
NumbersInString = FirstNumberInString & SecondNumberInString
End Function

View 9 Replies View Related

Finding The First Number In A String

Apr 8, 2007

We are trying to make either a macro or a function that will look through the contents of a cell, find the first NUMBER and then paste the results to another column. Below is an example of what may be in cell A1:

#BC7K,03/30/2007,0.00636,0.0069,0.00614,0.0062,0.0,0

We want only to find the FIRST NUMBER in this string, so the result should be 7.

View 5 Replies View Related

Lookup But First Finding A Unique String?

Jul 3, 2014

mockup.xlsxStarting out with a 9 by 11 grid.

Column A will have times that need to be referenced in a lookup. (Ex Sat 8:00am)

Row 1 will have basball field codes reference with a lookup. (Example Field 4

Cells B2:I11 have distinct codes or possibly nothing. (An example would be: Tier 1 A1-A3)

These codes will move around from time to time. They will always remain distinct within the grid, but could appear in any of the cells from B2:I11.

I have 2 columns I want to populate with values from the grid.

First is Fields. I want the first cell to populate with the baseball field found in row 1 of which the code Tier1 A1-A3 falls under.

For example if this season Tier1 A1-A3 is found in the column under Field 4, then I need to return Field 4 as a result.

Second is the time. I want the time to be populated based on what row the Tier1 A1-A3 code falls in.

For example if Tier1 A1-A3 is in the Sat 8:00am row, then I need that value returned.

In short, I need to search the grid and find a given value. I then need to use a lookup (or other tool) to return the first value in that row. And secondly via lookup return the first value in that column.

edit: added spreadsheet example. First sheet is grid in question, 2nd sheet is a typical schedule.

The first Team (Scared Hitless) is A1, the team they play first is Sands Duel Fuel (A3) They play at 11:00am on Field TR3.

You will see on the grid under TR3 and Sat 11:00 the code Tier 4 A1v3. This code is what I want to search and correlate into times on the schedule rather than doing the data entry by hand.

View 1 Replies View Related

Find Is Not Finding Character String?

Jun 11, 2014

I have a cell that has approx 22000 characters. I'm trying to remove a specific character string from a cell by doing a find and replace with "". It works for characters in the first part of the cell but not for characters in the last part of the cell.

Example: I do a find/replace for the characters 21242 to "" in column A and I get the expected results. I do a find/replace on 69294 to "", again I get the expected results, but if I do a find/replace on 85203 to "", I get "Excel cannot find what I am searching for" (but its there!)

My cell size is within the max size of 32,767 characters so not sure why its not working.

Attached a sample worksheet.

View 5 Replies View Related

Finding A Specific Integer In A String

Aug 3, 2009

I have a string in one of the following formats:

Banana 2, Orange 5, Lemon 0
Banana 7, orange/Lemon 9, cucumber 6
Melon/grape 3, Pineapple/ Orange 1
Banana 1, orangefruit/Lemon 2, pine 8

I would like to take out the first integer that comes after the word Orange (not case sensitive). I'm kinda at a loss here, how do I go about accomplishing this?

View 9 Replies View Related

Finding A String In A Column, Displaying YES On The Same Row

Feb 16, 2007

I am trying to search for a string of numbers (column 2) in an array, and have "YES" be written on the same line in column 3 if the string is found in the names ANYWHERE in column 1. Please see the desired results on the picture in column 3.

I have tried many things, including SEARCH function which can only work with 1 cell not many, COUNTIF and more advanced functions, but I think have not succeeded because of my lack of knowledge in arrays.

View 9 Replies View Related

Finding Location Of Last String Of 26+ Consecutive Blanks In Row?

Jan 18, 2013

I've attached an example of the data I am trying to solve this problem for. Basically I am looking for strings of 26 blanks or more in a row, but I want to determine the ending location of the last string of 26+ blanks. I've been able to determine the location of the maximum string of blanks, but that max group of blanks isn't always the last set over 26.

Any link to find the location of last string of blanks of 26 or more? The example I attached is a good example since there are two strings of 26+ blanks with the last one being shorter. I've also include the answer I'm looking at the end of the data in the example.

Example.xlsx‎

View 2 Replies View Related

Finding String In Excel Using VB6 ADO - Return Column And Row

Jul 13, 2011

I am trying to use ADO via VB6 to find a specific input in row A of my excel sheet.

I then want it to return the Column and Row to me separately.

I have a code I already use for returning specific values from cells:

Code:
Function Look(ClosedWorkbookFullName As String, _
SheetName As String, RangeAddress As String) As Variant

Dim conn As Object, rs As Object, SQL As String
Set conn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")

[Code] ......

Now I want something like this I can use as a function, but it obviously needs tweaks.

View 1 Replies View Related

Finding Date Within String (hyperlink) And Pasting Value

Feb 26, 2008

I have a sheet which contains a folder listing of files with the filename displayed as a hyperlink.

I would like to have a formula which works out a couple of values based on the file name which has been copied into a given cell as a hyper link.

In my sheet Column F contains the file names (as hyperlinks)

e.g. Anab AM1 2006-02-27.pdf
or CD 01_02 2006_05_18(2).pdf

I'd like to create a formula for Column A which will give me the first 2 blocks of text which are seperated by a space (in the examples above it would be "Anab AM1" and "CD 01_02") Anything after the second space should be ommited (including the 2nd space itself)

I'd also like column B to find the date within the filename. Note this is not always the rightmost part of the filename (excluding the .pdf) I've worked out I can use the Find function to find the '2006' (I'll always have the same year in here as my folder listings are sorted by year) but it returns the character where 2006 is located e.g. for "Anab AM1 2006-02-27.pdf" it gives me 10.

My date formats are always in the form yyyy-(or_)mm-(or_)dd

View 9 Replies View Related

If Text Found In String Return String

Jan 31, 2008

Find a short text string in a column of longer text strings and when that short text string is found return the longer text string that matches.

View 3 Replies View Related

Extract Text From Given Point In Text String When Data Points Do Not Share Given

Jul 9, 2014

I have a set of task descriptions that I am attempting to trend on. Some of these (Column B) have the customer's name added to the description; others do not. I need to be able to make a list of task names (ColumnA), removing the name from the text string.

The formula I am using is [=LEFT(B3,FIND("for",B3)-2)].

The problem I am having is when the description does not contain the "for" built into the formula, I get "VALUE" error. What adjustment can I make to the formula to pull over the Description if the "for" does not appear in the text string?

View 3 Replies View Related

Match Row That Contains Text Text String; List Associated Values From Pivot Table

Mar 28, 2009

refer to the attached workbook for reference. I am looking for a function in Sheet1, Column E that will search for the value of Sheet1, Column A within Sheet2, Column A. When a match is found, the function should look across Sheet2, Columns B - V for values of 1. When such values are found, the function should return the associated value from Sheet2, Row 2. There may be multiple values of 1, and as such, the function should separate values with a comma.

View 3 Replies View Related

Excel 2011 :: Find Multiple Text Strings In Another Text String

Mar 8, 2013

How do I use an Excel formula to find which (if any) multiple sets, each of up to 50 words, exist in a series of rows of a spreadsheet - if set A has one or more words found in a searched cell.

A positive result will return a specific value in the designated result cell. If none of the words in Set A is found in the searched cell, the formulae will repeat the test for the words in Set B, and so on.

After all 50 sets of words have been tested, the formula will move to the next cell in the searched column.

New words will be added to the sets of words continually as required.

Multiple words within sets are included in double quotes. Within each set of words there will be some n-tuples of words (i.e. 24 adjacent words) that contain one or more of the words in the set, but for which the formula will be required to return a negative result. Example: Set A = word 1, word2, word 3, "word1 word2 word3". (The words within a set could also be each entered in separate columns, as opposed to all included in a single cell.) The single column of text to be searched is about 10,000 rows.

I am wanting to use the above in a spreadsheet that contains data downloaded from a series of bank accounts to automatically allocate items of expenditure to one of 20 or so different categories of expenditure.

The formula will search the description field to find words that are used in the in the downloaded files from the various accounts to describe each transaction.

If a word describing travel expenditure (e.g. hotel, "holiday inn" but not "holiday travel") is found in the description of an expenditure item - the item cost will be allocated to the TRAVEL EXPENDITURE column, which is one of 20 or so different categories of expenditure.

Happy to consider a different solution if the task can be done better a different way.

Tried using a combination of INDEX/SEARCH/IF in Excel, but was not able to get a correct result. PS I am using Excel 2011 for Mac - which does not allow macros, so the solution needs to be entirely formula based.

View 1 Replies View Related

Extracting Phone Numbers From Text String Variation In Preceding Text

Mar 29, 2013

I'm pulling phone numbers out of text strings. There is text string ("Office:") indicating that the number following is an office number (the number that I need). MID and FIND take care of this. There are sometimes two instances of office numbers in single text string, so adding a second column using the third argument of FIND lets me start another search past the first instance of an office number. We have a bunch of office numbers with the qualifier "(Text)" after the original "Office" but before the phone number. How do I catch these ones?

View 8 Replies View Related

How To Split Text From Text String Into Separate Columns - No Delimiters

Apr 8, 2014

I have the cell data as below

How would I split into a new column the first part which is a date into a new column, then the country and the remainder into separate columns?

I still want the original data as I need to check that the splits worked well?

16.5.90 CH 1671/90-4
18.10.1991 CH 3056/91-1
24.07.92 ch 2341/92-2
30.7.92 ch 2395/92-3
18.11.92 Us 3533/92-5
26.5.93PCT 1577/93-0
9.8.93 CH 2363/93-8
17.8.93 CH 2445/93-0
25.1.94ch209/94-6;8.12.94ch3714/94-1
25.1.94 ch 209/94-6 ; 8.12.94 ch 3714/94-1
8.4.94 ch 1047/94-0
22.4.94 ch 1255/94-7
18.11.1992 CH 3533/92-5
18.11.1992CH 3533/92-5

View 2 Replies View Related

Compare Multiple Text Cells To One String Of Text And Return Specified Value

May 12, 2012

I have a dataset of shifts and want to compare each shift that needs to be filled to a list of requests for time off (vacation, etc).

For one cell the code is: =IF(ISERROR(SEARCH(B1, A1), 0,1)

Where A1 is the column of requests in comma delimited forme (ie: "AB,CD,EF").

Where B1 is the column containing the person assigned to shift 1 (ie: "AB")

In this case, would return a "1" as no error was returned, as AB was found in the list. Here "1" would represent a schedule conflict.

Without creating many cells for each shift- there are 20 shifts- can I create an array or string together this type of "SEARCH" function?

View 1 Replies View Related

Extract Multiple Text Strings From A Long Text String

Sep 4, 2009

An original text string entry appearing in an Excel cell would be:

"N7C Neuroprotective J5Z Antiviral, other M2Z Antiarthritic, other J5A Antiviral, anti-HIV"

I need to extract N7C, J5Z, M2Z and J5A from this string and list these alphanumeric values in separate cells adjacent to the original text string. The challenge is that these alphanumeric references may appear in different positions within the original string with no fixed value e.g. a "," separating them. The alphanumeric references may also be 3 or 4 characters in length and there may be different numbers of alphanumeric references in the original string.

Another example would be (very different from the first):

"T2Z Recombinant, other K5B Radio-chemoprotective J3Z Antibacterial, other D3A Vulnerary A10C Symptomatic antidiabetic K6Z Anticancer, other R8A Antiasthma B6A Septic shock treatment I1Z Immunostimulant, other S1Z Ophthalmological R8B Antiallergic, non-asthma M1A1 Anti-inflammatory"

You can see that in this further example "A10C" & "M1A1" are 4 character alphanumeric strings wheras the others feature 3 characters.

View 9 Replies View Related

Delete Row If Cell Contains Certain Text As Part Of Text String?

May 15, 2014

I have a column of data with letters in each cell, no numerical, only alpha. Now, some of those cells contain the letters "adj sub" as part of the text string in each cell. "Adj sub" is always at the beginning of the text string. As an example, a cell will look like this - "adj sub mhm". I want to delete rows whose cell description does not contain "adj sub" as part of the text in the cell.

View 5 Replies View Related

Loop And Parse All Occurrences Of Text After Text In A String

Nov 29, 2011

I am working on modifying this code (below) that I found here: VB Macro to search webpage for text string

Code:

Option Explicit
Public stResultstr As String
Sub SearchForString()
Dim rngURL As Range
Dim cll As Range
Dim stCheck As String
Dim xmlHttp As Object

[Code]...

So right now I have the script prompt you for a URL range, then it asks you for what you want to search for, and I have it set to return the next 10 characters from that found point.

You can see here:

Code:

If InStr(1, stResult, stCheck, vbBinaryCompare) > intt Then
intt = InStr(1, stResult, stCheck, vbBinaryCompare) + Len(stCheck)

I began to create something to identify the last position of the found item because next I want to loop it to find the next occurance of the same thing and return the next 10 characters after it in the next cell to the right in that same row:

Code:

cll.Offset(, 1).Value = stResultstr

Again, what I want to do here is find and parse out every occurence of a string (inputbox) found on a web page url in column A. The parse occurrences will go to the right in cells C though ? for row N.

View 2 Replies View Related

Excel 2003 :: Extracting Text From Text String?

Sep 17, 2013

Date: 17/09/2013 KO: 19:45 Ref: B Malone Att: 7,574 extraction of text from the above text string which is say in A1. What l need is for Date to go in A2, KO in B2, Ref in C2, & Att in D2. I'm using Excel 2003

View 7 Replies View Related

Partial Text Lookup In Text String And Return

Mar 15, 2007

Cell H1 has a variable string of references for eg
"FI570783AQ3516346EQ3516346FXVB123456"

I want to return the reference beginiing with "FXVA" so it would ignore the rest and only return FXVB123456 - this should always be 10 characters.

Just to add another complication to the mix, there may be 2 "FXVA" references in the string and i want to get both (these can be in the same string so FXVB123456FXEL123456 - but this might not happen regularly.

View 9 Replies View Related

Check If Text String In Cell With Other Text Is In List

Mar 27, 2008

I have a sheet in which some of the cells have two strings separated by a linefeed. I have come up with a cumbersome formula which will let me check if either of the two strings is a member of a list stored on another sheet. However, it fails if there is only one string in the cell, presumably as there is no linefeed for the formula to find. How can I modify the formula to cope with this situation?

There are also on occasions, three strings in the cell, but I can't seem to access the middle string with the formula. Simplified spreadsheet attached to show the problem. This must be formula-based, as we have a no VBA policy. If you think there is better way of doing this, please let me know.

View 3 Replies View Related

ADVERTISEMENT