Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two columns with strings of data as such:
Column A Column B 2008SPX850OCT0P2103 2008SPX850OCT0P2303 2008SPX855DEC0P208 2008SPX855DEC0P120 2008SPX855DEC-208C0 2008SPX855DEC-120C0 2008SPX1020DEC0P1022 2008SPX1020DEC0P1038 Is it possible to insert a space or comma between each number and text? I need to keep the minus sign(-) with the number that comes after it. e.g. Column A Column B 2008,SPX,850,OCT,0,P,2103 2008,SPX,850,OCT,0,P,2303 2008,SPX,855,DEC,0,P,208 2008,SPX,855,DEC,0,P,120 2008,SPX,855,DEC,-208,C,0 2008,SPX,855,DEC,-120,C,0 2008,SPX,1020,DEC,0,P,1022 2008,SPX,1020,DEC,0,P,1038 Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find String in another string - only between spaces | Excel Worksheet Functions | |||
Value between two spaces in a String | Excel Programming | |||
counting spaces in a string | Excel Programming | |||
counting spaces in a string | Excel Programming | |||
Count Spaces In A String | Excel Programming |