Hello,
I have the following column/row structure:
And I need to achieve this:
Please Login or Register to view this content.
So, basically move one specific text ("CD12') from Col3 and append it to Col2.Please Login or Register to view this content.
Can I do this in Excel?
Hi helloworld2012
Welcome to the Forum
One way
Put the string you want to move into a spare cell, I have used E1 and used a drop-down validation list to show you how it works.
Use helper columns (E & F in the attached example)
In E2
In F2Please Login or Register to view this content.
Drag/Fill both DownPlease Login or Register to view this content.
Copy the result and Paste Special > Values to where you want the final result
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks