I have given example in the screenshot. Please suggest any formula.
I have given example in the screenshot. Please suggest any formula.
Try this in B1
=SUBSTITUTE(A1,"(name)",C1)
Try this
in B1
Formula:Please Login or Register to view this content.
Or this
v A B 1 My name is (name) My name is (John)
Formula:Please Login or Register to view this content.
Last edited by AlKey; 11-03-2017 at 07:14 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
If need to change multiple values in the same cell like. My name is (name) my father name is (name)
Try this
=SUBSTITUTE(SUBSTITUTE(A1,"(name)",C1,1),"(name)",D1)
I want this actually as you can see in the image
Untitled-1.jpg
(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!
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks