hey all,
I have a single cell containing : A. Test, B.Test, C. None, C.Test, C.Test2
I need to convert only the C's in the field to separate columns. So I want 3 columns - C.None, C.Test and C.Test2.
I dont want to go the text to columns or the vba way. Can some help me with a formula?
Use the Text to Column but select Fixed Width
then simply move the sections so you only have the C' selected.
EDIT ADDED: Forget the above, I see you don't want to use Text to Columns.
Last edited by xenixman; 03-28-2012 at 04:28 PM.
inelegant solution - i hope that an expert chimes in with a prettier approach.
Last edited by icestationzbra; 03-28-2012 at 04:44 PM. Reason: fixed issues...
Thanks, icestationzbra. This works!Originally Posted by icestationzbra
or try this.....
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks