tags:

views:

188

answers:

2
+1  Q: 

Excel find and replace a character to create a new cell

For example if have " size:1, color:red CH 4" in one cell i want " size:1. color:red" new cell "4"

basically find "CH" and replace it with a new cell and everything in front of it. anyone know how?

+1  A: 
cinqoTimo  2010-01-30 22:02:30
seems like you know what your talking about, i got the jist of it.so if i want to do this 300 listing they all have to be the same length stringand could you give a example?thanks
 2010-01-30 22:32:51
A: 

http://www.youtube.com/watch?v=aTmDPayW9bg

 2010-01-30 23:19:27

related questions

Win32 ShellExecute and a UNC Path
Tool to reformat xml-comments (Visual Studio 2008)
Excel - Macro to conditionally copy rows to another worksheet
Excel Macro Help
MS Word: How do I create a shortcut or toolbar button for the "Paste Special..Unformatted Text" option?
How can I find last row that contains data in the excel sheet with a macro?
How can I refresh all the pivot tables in my excel workbook with a macro?
Writing a ++ macro in Common Lisp
is there a way to write macros with a variable argument list in visual C++?
My first Lisp macro; is it leaky?
How do I save each sheet in an Excel workbook to separate CSV files with a macro?
How do I keep RecipientTime when executing MailItem.Move in an Outlook macro?
How do I assign a keyboard shortcut to a VBA macro in Outlook 2007?
Modifying a spreadsheet using a VB macro
How to disable Visual Studio macro "tip" balloon?
What are the best keyboard macros for programming in windows?
good directory picker for visual basic macros in MS Outlook (2007)
VS2008/TFS: Get Latest of solution from command line or macro
Helpful snippits?
How to enable the TRACE macro in Release mode?
How do you create a debug only function that takes a variable argument list? Like printf()
Do you have any recommended macros for Microsoft Visual Studio?
[ADO.NET] What's the deal with |Pipe-delimited| variables in connection strings?
Visual Studio 2005 Macros stop working when Visual Studio 2008 is installed
How far can LISP macros go?