Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split Text in a Cell (4 columns)
Dear Expert,
I have asked similar question before. But I asked to split into 3 columns. Now is it possible to split into 4 columns please? First column is the text before ° Second column is the text after ° but before the numerical figure Third column is the text before ' Forth column is the text after ' Say for an example ... In a cell has the info like this ... 07°Pi25'Rx 4 columns should be split into these. 07 °Pi 25 'Rx Thanks so much for help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split Text in a Cell (4 columns)
Is your text value **always** two digits followed by the ° symbol followed
by two letters followed by two digits followed by the apostrophe symbol followed by two letters? Also, are you looking for a VB or Excel formula solution? -- Rick (MVP - Excel) "Elton Law" wrote in message ... Dear Expert, I have asked similar question before. But I asked to split into 3 columns. Now is it possible to split into 4 columns please? First column is the text before ° Second column is the text after ° but before the numerical figure Third column is the text before ' Forth column is the text after ' Say for an example ... In a cell has the info like this ... 07°Pi25'Rx 4 columns should be split into these. 07 °Pi 25 'Rx Thanks so much for help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying text to split into columns | Excel Worksheet Functions | |||
Insert columns and split text | Excel Programming | |||
Text to columns, split at first space only | New Users to Excel | |||
split text into more columns excel | Excel Programming | |||
How do I split 16 char text 'XX XXX= +. X' into 16 columns | Excel Discussion (Misc queries) |