Remove characters

[inyimanyimo]

Hi guys, I have a question.

Brechin Plc+F1570
Collingwood Plc+F4393
Dornberg Cl+F687
Holdenhurst Av+1402

It should be Brechin Plc, Collingwood Plc, and so on.

Anyone can help to remove +F...?
I really appreciate your help, thank you.

[GC Excel]

Hello and welcome to the forum,

Try this formula :

Please Login or Register  to view this content.

[inyimanyimo]

Hi thanks it's working.

But in this case i have 5000 records, so it only affected to that 4 records, and the others will be error.
Can you help this one as well?

[GC Excel]

Can you provide a sample workbook with more records?
Are they different?

[inyimanyimo]

Can you provide a sample workbook with more records?
Are they different?

For example:

Abbotsbury Mews
Adams Close
Brechin Plc+F1570
Collingwood Plc+F4393
Naoroji Street
Newdigate
Shamrock Way
Dornberg Cl+F687
Holdenhurst Av+1402
Beechwood Close
Bergen Square
Monson Road

The other records don't have +...

[FDibbins]

Hi, welcome to the forum

I suggest that upload a small (clean) sample workbook (not a pic or copy/paste examples here) of what you are working with, and what your expected outcome would look like.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[inyimanyimo]

Here's the data

[inyimanyimo]

Thank you. I already uploaded.

[AlphaRaveNZ]

Hi, if all you want to do is remove the +...,
1. Press CTRL+F, click the find & replace tab at the top of the window.
2. In the FIND box, type "+*" (without the quotes).
3. Leave the REPLACE box blank.
4. Highlight the entire "Street" column.
5. Click "Replace All".

Hope this helps. Should be no need for formulas here (unless i'm misunderstanding what your trying to do)...

[inyimanyimo]

Hi, if all you want to do is remove the +...,
1. Press CTRL+F, click the find & replace tab at the top of the window.
2. In the FIND box, type "+*" (without the quotes).
3. Leave the REPLACE box blank.
4. Highlight the entire "Street" column.
5. Click "Replace All".

Hope this helps. Should be no need for formulas here (unless i'm misunderstanding what your trying to do)...

Hi, thanks it's working well!!!
thanks for helping

btw, there is a record like Barili(?) Lodge. Again how can I remove (?) ?

[AlphaRaveNZ]

All you need to do is put "(?)" into the FIND box and leave the REPLACE box blank again. Click REPLACE ALL and this will remove all the "(?)" from the column (remember to highlight the STREET column).

[inyimanyimo]

alright thank you guys for helping

have a nice day!