Excel Formula

Watu wangu, i am trying to separate a lot of data in the form below:

OaklandCA
PleasantonCA

Ikue

Oakland, CA
Pleasanton, CA

Best formulae to use ni gani other than flash fill?

Find “CA” and replace “, CA”

Sasa kuna zingine ziko na
Belle MeadNJ

and

Forest HillsNY

Ingiza power query or use office 365 and do a flash fill. Leta elfu moja nikuoneshe how to go about that.

Find and replace step by step

thanks all, i would have used flashfill but interview wanted to see a formula. So i used
=LEFT(A3,LEN(A3)-2)
=RIGHT(A3,2)
=IFERROR((CONCATENATE(E3,", ",F3)),0)

Belle MeadNJ

=LEFT(A3,LEN(A3)-2) – Belle Mead
=RIGHT(A3,2) – NJ
=IFERROR((CONCATENATE(E3,", ",F3)),0) – Belle MeadNJ, NY

Then text to column to separate them. Not bad, but that is a terrible interview. They should focus on the answer. Imagine working and going for the long method…not efficient. You probably should not interview there.

:rolleyes::rolleyes::rolleyes:
Sasa nini inaendelea hapa apart from CTRL+F nimeona Greek tu.

Yule MTU atakaa chini anifunze all the basics of Excel nitamkanja kitu poa

Teach me more about in depth Excel.

Leta kakitu…but seriously ingia youtube. ama uliza maswali specific nitakusaidia

U

On the next row, use Data, Text to Columns. Then use Concatenate to join the two

There are many way to go about it

Hata mimi nimekubali nilikuwa nalala kwa IT class. I can never understand any threads posted here on this subject.

Sidhani Excel iko IT. Hii ni kitu ya kawaida in all departments at a workplace.

Ingia youtube ama Udemy.

Update - Nilipita na nikawai io kazi - but sasa ni kuingia tutorials za Advanced Excel

Hebu ukipata izo tutorials upost links hapa

Congratulations. Nitatuma pay bill ulipe matumbo ugali.

Power query, M na DAX, wachana na vba.