I need to generate a second column from value of the first column. The value in the first column is like this "IDS1577701<!>IDS1577702<!>IDS1577703". The value I want in the second column is "IDS1577701XX<!>IDS1577702XX<!>IDS1577703XX".
I'm a newbie using excel and I'm not know much about combination of formula but I think this can be done using excel function and not need VS script (which I don't know either). Does anyone ave any suggestion for this?
Thanks in advance
Last edited by NBVC; 03-20-2011 at 07:16 PM.
Taking you literally, that you actually want XX's in there.
Try:
=SUBSTITUTE(A1,"<!>","XX<!>")&"XX"
where A1 contains original string.
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.
Cool thanks, it works. It's so simple now I'm thinking about it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks