captenblack
New Member
- Joined
- Nov 13, 2009
- Messages
- 5
Hello, I'm sure there is a quick and easy way to do this. All content is in column A. I want to move the word "Module" and a #.# that appears after it from the end to beginning of cell and add a colon and space. The text to be moved will always be the same (Module) as shown in examples, the numbers will be different but always #.# format. There is nothing AFTER the numbers in the cells right now, cells always end with #.#. The text prior to "Module" is always random and varies in each cell. Sample of how it currently appears --> how I would want it to appear:
Assisting Others Module 19.4 -->
Module 19.4: Assisting Others
Communicating with Others Efficiently Module 2.4 -->
Module 2.4: Communicating with Others Efficiently
Building and Organizing Proposals and Opinions Module 15.10 -->
Module 15.10: Building and Organizing Proposals and Opinions
Creating & Completing Important Requests Module 5.13 -->
Module 5.13: Creating & Completing Important Requests
Thanks for any help.
Assisting Others Module 19.4 -->
Module 19.4: Assisting Others
Communicating with Others Efficiently Module 2.4 -->
Module 2.4: Communicating with Others Efficiently
Building and Organizing Proposals and Opinions Module 15.10 -->
Module 15.10: Building and Organizing Proposals and Opinions
Creating & Completing Important Requests Module 5.13 -->
Module 5.13: Creating & Completing Important Requests
Thanks for any help.