Populate a column based on the cell next to it

[MadHatsJess]

Hi, hoping someone can help

Example

Cell A
1 10 Weeks
2 12 Weeks
3 22 Weeks

I need column B to populate based on the value of cell A. For example "10" "12" "22"

I have around 60 variations.

I have had a look around online and think IFS would work but it doesn't work on my version of excel.

Thanks

Jess

 

[cooper645]

We need more info ideally, do you just want to extract numbers from the let or a certain number of characters or all before the first space?

For example if if it was just two numbers then the following would work:
=LEFT($A1,2) Entered in B1 and drag it down for however many rows of smarts younhave.

 

[cooper645]

Also knocked this one up

=LEFT($A1,(FIND(" ",$A1,1)-1))

which extracts everything before the first space. Hopefully there is a solution here for you. I’m off to bed but will check back in the morning to see if anything further is required.