Hi,
I'd like to add brackets or quote marks around words in column A based on the word in column B.
For example:
pretty flowers | exact
bright flowers | phrase
large yellow flowers | exact
Will become:
[pretty flowers]
"bright flowers"
[large yellow flowers]
How would I go about accomplishing this task?
Assuming your data is in A1:B3, then in C1:
=IF(B1="exact","["&A1&"]",IF(B1="phrase",""""&A1&"""",A1))
copied down
Then you can copy and paste special >>> values over column A, if desired and delete column C.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks