| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete etxra information from cells
I need to delete information in cell
for example if A2= http://google.com/help/you/me I want to remove everything after "com" So i would want A2 = http://google.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete etxra information from cells
=LEFT(A2,FIND("com",A2)+2)
-- Kind regards, Niek Otten "Shani" wrote in message oups.com... |I need to delete information in cell | | for example if A2= http://google.com/help/you/me | | I want to remove everything after "com" | | So i would want A2 = http://google.com | |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete etxra information from cells
Try something like
Dim Pos As Long Pos = InStr(Range("A1").Text, ".com") If Pos = 0 Then Exit Sub End If Range("A1").Value = Left(Range("A1").Text, Pos + 3) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Shani" wrote in message oups.com... I need to delete information in cell for example if A2= http://google.com/help/you/me I want to remove everything after "com" So i would want A2 = http://google.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete etxra information from cells
thank you very much
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete rows if AF and AY empty but F has information | Excel Worksheet Functions | |||
| Delete rows in a workbook that contain the same information | Excel Worksheet Functions | |||
| sort and delete rows of information | Excel Discussion (Misc queries) | |||
| how do i delete some information from different cells at time | Excel Discussion (Misc queries) | |||
| Have VBA delete a group of cells, move information over, then add | Excel Discussion (Misc queries) | |||
Hybrid Mode
