Keeping only specfic text in a cell
Solved/Closed
noobkelsey
Posts
3
Registration date
Friday March 26, 2010
Status
Member
Last seen
March 26, 2010
-
Mar 26, 2010 at 08:55 AM
noobkelsey Posts 3 Registration date Friday March 26, 2010 Status Member Last seen March 26, 2010 - Mar 26, 2010 at 10:39 AM
noobkelsey Posts 3 Registration date Friday March 26, 2010 Status Member Last seen March 26, 2010 - Mar 26, 2010 at 10:39 AM
Related:
- Keeping only specfic text in a cell
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Based on the cell values in cells b77 - Excel Forum
- An example of a cell is a blank cell ✓ - Programming Forum
- Count if cell contains number - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 26, 2010 at 10:28 AM
Mar 26, 2010 at 10:28 AM
Assumptions
1. The data is in column A
2. The result is to be shown in column B
1. The data is in column A
2. The result is to be shown in column B
Sub extractMV() Dim lMaxRow As Long Dim rowIdx As Long Dim inString As String Dim outString As String Dim sTemp As String Dim iLoc As Integer lMaxRows = Cells(Rows.Count, "A").End(xlUp).Row For rowIdx = 2 To lMaxRows inString = Trim(Cells(rowIdx, "A")) outString = "" iLoc = 0 sTemp = "" iLoc = InStr(1, inString, ",") Do While (iLoc > 0) sTemp = Trim(Left(inString, iLoc - 1)) If (Left(sTemp, 6) = "SEA-MV") Then outString = outString & ", " & Mid(sTemp, 5) End If inString = Trim(Mid(inString, iLoc + 1)) iLoc = InStr(1, inString, ",") Loop If (Left(inString, 6) = "SEA-MV") Then outString = outString & ", " & Mid(inString, 5) End If If (Left(outString, 1) = ",") Then outString = Trim(Mid(outString, 2)) End If Cells(rowIdx, "B") = outString Next End Sub
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 26, 2010 at 09:43 AM
Mar 26, 2010 at 09:43 AM
What version of xl you have ?
noobkelsey
Posts
3
Registration date
Friday March 26, 2010
Status
Member
Last seen
March 26, 2010
Mar 26, 2010 at 10:03 AM
Mar 26, 2010 at 10:03 AM
Sorry 2003
Mar 26, 2010 at 10:39 AM