Break up strings into separate cells

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 118

Break up strings into separate cells

What code do I need to split Id Numbers & characters in separate cells?
eg
V080779382799E
how can I have V in a separate cell, 0 in cell next to it, 8 in next
cell to the right and so on

thxs

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
separate strings	cz1	Excel Discussion (Misc queries)	2	October 29th 09 10:07 PM
Break master list up into lists in separate worksheets	Prashant Rao	Excel Discussion (Misc queries)	0	September 20th 07 08:28 PM
how do i separate 2 strings of a cell in different cells?	Bona	Excel Worksheet Functions	1	July 26th 07 11:32 AM
I want to take a date 2006/02/10 & break it into separate columns	Curtis	Excel Worksheet Functions	3	September 20th 06 06:13 PM
Match data of two identical strings in two separate spreadhseets	Mahendra	Excel Discussion (Misc queries)	0	September 14th 05 11:40 PM

All times are GMT +1. The time now is 04:57 AM.

Menu

About Us