I'm not really sure what you'd call it...

[obviousnoob]

Hello everyone, thank you for taking the time to view my post. I have an issue in excel which I hope you all would be able to help me with. Thank you in advance, kind peeps.

The condition is:
1. In the same cell, automatically replace any number, e.g.
(267) 339-9379 --> No name 267-339-9379
(267) 350-9380 --> No name 267-350-9380


I wonder if this is possible, thank you all once again!

[Gregb11]

A cell can only contain a value or a formula, not both. So you can't replace something in the SAME cell, unless you use VBA. Is that what you're looking to use? Also, read the yellow banner at the top of the page to attach a good sample file.

[obviousnoob]

Thank you for the reply!
I see.. could you please teach me how I would go about it in a different cell..?

Much thanks!!

[Gregb11]

Did you read the yellow banner?

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[obviousnoob]

Hello, deeply sorry for my late replies. I'm sorry I wasn't able to look at it clearly when I wrote this post, I was thoroughly busy during that time. I'll make sure to comply to the forum's rules next time I post. Thank you. if you all don't mind, I'll be doing a follow up on this post within the next few hrs. I'll just attach the excel file.

[alansidman]

You really need to change the post thread title before any one can offer any help. Please re-read post #5 for instruction.