Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
moving numbers from text into new cells
Phreakenstien,
Have you considered using "Text To Columns" using the "space" deliminter? Columns("A:A").Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=xlNone, ConsecutiveDelimiter:=False, Tab:=False, _ Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo _ :=Array(Array(1, 1), Array(2, 1)), TrailingMinusNumbers:=True Hope that helps. -- Thx MSweetG222 "phreakenstein" wrote: example before a b Sam 12 Luke 19 John 13 After a b Sam 12 Luke 19 John 13 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving text around cells without moving boarder lines | Excel Discussion (Misc queries) | |||
cells containing text and numbers | Excel Discussion (Misc queries) | |||
cells containing text and numbers | Excel Discussion (Misc queries) | |||
Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
Moving, deleting, and concatenating text in cells. | Excel Worksheet Functions |