Delete everything in a cell AFTER a comma

DKcrm

New Member
Joined
Mar 2, 2006
Messages
40
Hi

I'm a board member in a voluntary organisation and would like to plot our members adresses in a map using MapPoint.

Our memberlist is in excel with the addresses stated as following: Street #, floor. door/side. (example: Peder Jakobsens Gade 8, 2. th. - (in English: 8 Peder Jakobsens Street, 2nd floor, right))

The thing is just, that MapPoint doesn't recognize a street address if I have informations like floor, door etc. so I need a formula that removes the comma and everything after it.

I found this link: http://www.mrexcel.com/board2/viewtopic.php?t=216656 but that seems to delete everything BEFORE the comma, and I can't see how I turn it around - I'm not an excel pro..

SO - Who will help me?

The output data should be (in example) Peder Jakobsens Gade 8 - no comma's and nothing after the comma...
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Do you need a formula? You can do a search & replace using a wildcard.

Ctrl-H

Search for: ,*
Replace with: [leave this blank]
 
Upvote 0
Do you need a formula? You can do a search & replace using a wildcard.

Ctrl-H

Search for: ,*
Replace with: [leave this blank]

You're right ... I was just so focused that this was only possible by using a formula - I didn't think about that I've done this in word a couple of times like you explain it...

As a formula:

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

Thank you very much - it worked as planned :)
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,937
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top