Hy all
i attached some file
in this file, ther's old text and new text coloumn which contain long text in a cell
to make it clear, i attach a picture
Untitled.jpg
how to replace a specific text:
1. the name XXX with cell B3
2. username with with cell C3
3. password with cell D3
the output is just like New text
thankyou so much for the help
Last edited by adekinteristi; 12-21-2017 at 04:00 AM.
Try
F3Formula:
Please Login or Register to view this content.
Copy down!
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Try this:
Please Login or Register to view this content.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thankyou so much for the quick respon
and it solved :D
thanks
You're welcome!
i want to ask about the "&B3&"
what the use for "& &"
is it to make the function to call the cell?
and why the last formula only contain "&D3, without &" on the last
It is used to concatenate the text and the contents of the cell. It works like this:
="text text"&cell_reference&"more text"
awesome
thankyou so much
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks