Try this in C3 and fill down. This will return the value in column A without the value in column B
Copy column C and Paste values (in place) to get rid of the formulae then copy and paste back into column A.
Result before copying back to column A
|
A |
B |
C |
2 |
Address |
City |
|
3 |
11305 Via Balboa Anchorage |
Anchorage |
11305 Via Balboa |
4 |
P.O. Box 3652 35670 Kenai Spur Hwy. Ste. 102 Soldotna |
Soldotna |
P.O. Box 3652 35670 Kenai Spur Hwy. Ste. 102 |
5 |
P.O. Box 2721 Soldotna |
Soldotna |
P.O. Box 2721 |
6 |
106 US Hwy 31S Bay Minette |
Bay Minette |
106 US Hwy 31S |
7 |
P.O. Box 361386 Birmingham |
Birmingham |
P.O. Box 361386 |
8 |
1703 Center Point Pkwy Center Point |
Center Point |
1703 Center Point Pkwy |
9 |
2422 Danville Road Suite C Decatur |
Decatur |
2422 Danville Road Suite C |
10 |
2006 Franklin Street Suite 106 Huntsville |
Huntsville |
2006 Franklin Street Suite 106 |
11 |
2152 Airport Blvd # 106 Mobile |
Mobile |
2152 Airport Blvd # 106 |
12 |
P.O. Box 8407 Mobile |
Mobile |
P.O. Box 8407 |
13 |
6316 Piccadilly Square Drive Suite A Mobile |
Mobile |
6316 Piccadilly Square Drive Suite A |
14 |
8066 Crossbow Ln. Theodore |
Theodore |
8066 Crossbow Ln. |
15 |
1409 Inverness Parkway Tuscaloosa |
Tuscaloosa |
1409 Inverness Parkway |
16 |
Tuscany Podiatry 215 Hargrove Rd. E. Tuscaloosa |
Tuscaloosa |
Tuscany Podiatry 215 Hargrove Rd. E. |
17 |
Cabot Foot Clinic 3065 Hwy 367
Cabot |
Cabot |
Cabot Foot Clinic 3065 Hwy 367
|
18 |
1000 Windover Suite A Jonesboro |
Jonesboro |
1000 Windover Suite A |
19 |
Foot & Ankle Center of Little Rock 10020 West Markham St. Little Rock |
Little Rock |
Foot & Ankle Center of Little Rock 10020 West Markham St. |
20 |
1117 McLain St. Newport |
Newport |
1117 McLain St. |
Here is your workbook to experiment with:
Bookmarks