Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
split cell content without using a specific character/sign
Roger,
One way:- Sub Test() Dim intA As Integer, strB As String Dim strC As String, Var Var = ActiveCell.Value ' (or whatever) intA = Left(Var, 2) strB = Mid(Var, 3, 1) strC = Right(Var, 1) End Sub This only works if the format of the target is always the same. regards' Don -- "Roger" wrote in message om... Hi All, I have an issue with how to split cell content without using a specific character/sign. Eg The content of a cell is 13GR. The searched result after the splitting of the cell content shall be: intA= 13 strB = G strC = R How should the code be written to solve the issue? I would be very grateful for help. Roger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split the content of cell | Excel Worksheet Functions | |||
Split cell content | Excel Discussion (Misc queries) | |||
How to split Cell content into two resulting cells | Excel Worksheet Functions | |||
sort starting from a specific character (@ sign) for email addres | Excel Discussion (Misc queries) | |||
Split cell values based on content | Excel Worksheet Functions |