ste

  1. E

    Search Excel column from within Access question

    I'm writing some VBA code that should search for certain words in the Address1 field (e.g., "Suite", "Ste", "Apt") then copies the word and what follows it to the Address2 column. I also need it to truncate the Address1 value so that the word and what follows it no longer appears there. For...
  2. T

    Formula to Separate City from Address

    I have a list that looks like: <tbody> Address 1820 E River Rd Ste 230Tucson 7550 E Mcdonald Dr Ste AScottsdale 442 Kaleimamahu StHonolulu 6 Larch Ave Ste 398Wilmington 85 Willow StNew Haven 64 Thompson St Ste A105East Haven PO BOX 2590416 Slater RoadNew Britain 7059 Blair Rd...
  3. J

    Splitting addresses into different cells

    I need to separate addresses that are in one cell into address,city,state,zip cells. There isn't a consistent deliminator and I can only get ad far as pulling out the state and zip. Below is a sample of the info that I need to be separated. I think I've sprouted my first grey hair from this...
  4. S

    greater than function (Index,Match....)

    hi just trying to find a Name based of the score this is just an example on my excel sheet its has got much more teams and names so it will take a long time to use IF function Team 1 Jack, Dave, Mark and Tony Team 2 Kev, Ste, Mike and Bob if I want to give 40 to team 1 it should come up...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top