Pull through partial information from one column depending on what is in another column

I am trying to group browser versions together in a large spreadsheet, but the raw data I have if much more detailed than I need. So - for example, I don't need to know it's Chrome 20.0.1132.57, Chrome 20 will suffice. (see below or the attachment for full list of possible actions).

So I would like to create a new column which pulls through part of the string in column B, depending on what browser I am referring to (column A).

Would an IF statement be too clunky for this?

Thanks

Glayva

Required actions:

- if it’s a Chrome or a Firefox browser, I want to return everything before the first dot
- for Safari I want to return the first number of the string
- for everything else (including IE) I want to copy everything in the cell over.

Hi

A little bit clunky but try =IF(A3<>"Internet Explorer",IF(A3="Safari",LEFT(B3,4),LEFT(B3,2)),LEFT(B3,1)) in D3 and drag down.

The only problem is the 2 different string lengths for Safari adds the . for short versions.

I see where you are going with this, but it's actually not quite what I need.

I only need the first digit of the Safari string, so that's easy enough to amend. However, I need to copy the *whole* of the cell over to the new column if the value in column A is anything but Chrome, Firefox and Safari.

With the suggested formula IE 10 would turn into IE 1 for example (there are other variations I require that for too but they all come under the 'nto safari / chrome / firefox category).

Also - with this formula Firefox 9.3.1 (for example) would render as "9." wheras I am looking for it to render as simply "9" (i.e. everything before the dot)

As I say - not sure if it's an IF statement I need or another formula (possibly with helper coulmns).

Thanks

Glayva