About Us

Don Guillett

glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"aileen" wrote in message
...
This worked perfectly...Thanks!

"Don Guillett" wrote:

for the data given, this should do it.

Sub breakitup()
For Each c In Range("c2:c10")
If Len(c) 3 Then
c.Offset(, 1) = Mid(c, 3, 1)
c.Offset(, 2) = Mid(c, 4, 2)
End If
Next c
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"aileen" wrote in message
...
I have a column of data as such:
ESZ8
ESZ10
SPT
SPY
SPV
ESH9
SPC12

For the celss that have more than 3 characters I would like to separate
the
data into new columns as follows: ignore the first 2 characters then
place
the 3rd character in a new column and any remaining characters which
will
always be numbers in another column.

e.g
A B C
ESZ8 z 8
ESZ10 z 10
SPT
SPY
SPV
ESH9 h 9
SPC12 c 12

Is this at all possible? As usual, thank you for any help you can
give.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
return value based on number of characters in cell / field	Perplexed	Excel Worksheet Functions	4	December 10th 08 08:48 PM
Deleting rows based on number of characters	catalfamo1220	Excel Discussion (Misc queries)	3	July 20th 06 06:31 PM
moving cells to another column based on number of characters	JOUIOUI	Excel Programming	1	June 8th 06 01:42 PM
Split field based on number of characters and space	william_mailer	Excel Worksheet Functions	6	February 10th 06 01:26 AM
Split field based on number of characters and space	william_mailer	Excel Programming	6	February 8th 06 05:22 PM