time entry worksheet.xls
The attached worksheet is an example of what I am trying to do in my master spreadsheet. In the "Description" field, the text has the symbols '*' and '**'. The information in the two following columns (Who? and Content?) are supposed to be inserted into the Description field, replacing the asterisks. Is there a formula that can be created to do this? I'm still a newbie and this is way over my head!
Thanks in advance!
Last edited by alannanoelle; 01-20-2012 at 07:10 PM.
In cell D2 try the formula:
=SUBSTITUTE(SUBSTITUTE(A2,"**",C2),"*",B2)
Is that doing what you're looking for?
alannanoelle,
In cell D2 and copy down:
=REPLACE(REPLACE(A2,FIND("*",A2),1,B2),FIND("**",A2)+LEN(B2)-1,2,C2)
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Andrew-R beat me to it, and he did it the smart way, go backwards, lol
Perfect, thank you!
People often call my formula backwards, but this is the first time it's sounded like a complimentOriginally Posted by tigeravatar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks