How to extract cell text to other cell text in bracket

Try this
in B1

Formula:

Please Login or Register  to view this content.

v	A	B
1	My name is (name)	My name is (John)

Or this

Formula:

Please Login or Register  to view this content.

Originally Posted by robinwindsor

If need to change multiple values in the same cell like. My name is (name) my father name is (name)

It is your direct responsibility to provide accurate requirements. There is nothing in your original post suggests there will be "mother" or "father" or any other relatives.

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!