Remove this Banner Ad

Mega Thread The Questions Thread - Part II

🥰 Love BigFooty? Join now for free.

Status
Not open for further replies.
I was discussing garlic with a mate today.

She reckons you can just "tear out" one or two bits of it rather than purchasing the whole bulb.

Is this for real? :confusedv1:
She sounds like a self-service checkout superstar

She's clearly not someone with a Mediterranean background. "One or two bits" is adequate garlic for a quarter of a Salada
 

Log in to remove this Banner Ad

Guys there has been a lot of conjecture in our office today about how you eat your pasta.

Do you guys eat it in a bowl or on a plate?

Majority of people have said bowl.
I like a flat bottomed bowl
Excel spreadsheets with an entire address in one cell. Is there a way to split, copy and paste in to 3 cells. One each for street, suburb and postcode.
Or dies it need to be done manually?
Use Flash Fill

If your address is in column A, type the street into B, suburb into C and postcode into D

Do a few rows, then highlight what you've typed and on the Home tab go to Fill (over on the right usually, depends on your version of Excel) and from the drop down select Flash Fill

It should recognise the pattern and pull out what you need for each row in column A



EDIT: looks like in newer versions of Excel the Flash Fill button is on the Data tab
 
Last edited:
I like a flat bottomed bowl

Use Flash Fill

If your address is in column A, type the street into B, suburb into C and postcode into D

Do a few rows, then highlight what you've typed and on the Home tab go to Fill (over on the right usually, depends on your version of Excel) and from the drop down select Flash Fill

It should recognise the pattern and pull out what you need for each row in column A
Holy shit this is fantastic. Not perfect, but a massive help. Thanks.
 
I like a flat bottomed bowl

Use Flash Fill

If your address is in column A, type the street into B, suburb into C and postcode into D

Do a few rows, then highlight what you've typed and on the Home tab go to Fill (over on the right usually, depends on your version of Excel) and from the drop down select Flash Fill

It should recognise the pattern and pull out what you need for each row in column A



EDIT: looks like in newer versions of Excel the Flash Fill button is on the Data tab
Thanks, I knew there had to be a way
 

Remove this Banner Ad

🥰 Love BigFooty? Join now for free.

Status
Not open for further replies.

Remove this Banner Ad

🥰 Love BigFooty? Join now for free.

Back
Top