Omer
05-07-2016, 12:51 AM
How do I check Cell content starts with text using vba?
I am trying to fix address in column E, if cells in column E starts with text then copy the cell value on the right side column F
Example
Before
+-------------------------+------------------+
| Address ColE | Suite ColF |
+-------------------------+------------------+
| 1440 CAR PKWY | APT 19205 |
| 69 BELLA | |
| 860 VALLEY PRKY | APT 2094 |
| 200 CENTURY CENTER BLVD | SUITE100 |
| ONEWAY BLVD | 7700 ONEWAY BLVD |
+-------------------------+------------------+
After
+-------------------------+------------------+
| Address ColE | Suite ColF |
+-------------------------+------------------+
| 1440 CAR PKWY | APT 19205 |
| 69 BELLA | |
| 860 VALLEY PRKY | APT 2094 |
| 200 CENTURY CENTER BLVD | SUITE100 |
| 7700 ONEWAY BLVD | |
+-------------------------+------------------+
Can someone help me with vba example, on how to do this- Thanks
I am trying to fix address in column E, if cells in column E starts with text then copy the cell value on the right side column F
Example
Before
+-------------------------+------------------+
| Address ColE | Suite ColF |
+-------------------------+------------------+
| 1440 CAR PKWY | APT 19205 |
| 69 BELLA | |
| 860 VALLEY PRKY | APT 2094 |
| 200 CENTURY CENTER BLVD | SUITE100 |
| ONEWAY BLVD | 7700 ONEWAY BLVD |
+-------------------------+------------------+
After
+-------------------------+------------------+
| Address ColE | Suite ColF |
+-------------------------+------------------+
| 1440 CAR PKWY | APT 19205 |
| 69 BELLA | |
| 860 VALLEY PRKY | APT 2094 |
| 200 CENTURY CENTER BLVD | SUITE100 |
| 7700 ONEWAY BLVD | |
+-------------------------+------------------+
Can someone help me with vba example, on how to do this- Thanks