CODEWITHSUNDEEP
excel
MeltingDog
MeltingDog

Reputation: 15404

MS Excel: Delete data in cells before first instance of character

I have a column with data like

12 Frankton Rd, Queenstown 9300, New Zealand

I want to delete the information before the first comma, so the above becomes:

Queenstown 9300, New Zealand

Of course if I use Find and Replace with *, this deletes the city name as well, so I can't use it.

Would anyone know how to achieve this?

Edit: After trying =MID(B2,SEARCH(",",B2)+1,LEN(B2))

enter image description here

Upvotes: 0

Views: 33

Answers (1)

bzimor
bzimor

Reputation: 1628

Assume that your address string is in cell A2. Then use this formula:

=MID(A2,SEARCH(",",A2)+2,LEN(A2))

1

Upvotes: 1

Related Questions