| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Col. split
Hi Group, I have few sheets with col containing data " 123 4567" I want this to be split in 2 dif col where space occurs. sometimes there are 4 digits in first set like "1234 5678" Any help would be apprecited. Thanks Sazi -- sazi ----------------------------------------------------------------------- saziz's Profile: http://www.excelforum.com/member.php...nfo&userid=635 View this thread: http://www.excelforum.com/showthread.php?threadid=57088 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Col. split
select the column,
do Data=Text to Columns selected delimited then select space as the delimiter -- Regards, Tom Ogilvy "saziz" wrote: Hi Group, I have few sheets with col containing data " 123 4567" I want this to be split in 2 dif col where space occurs. sometimes there are 4 digits in first set like "1234 5678" Any help would be apprecited. Thanks Saziz -- saziz ------------------------------------------------------------------------ saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350 View this thread: http://www.excelforum.com/showthread...hreadid=570887 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Col. split
Say your string is in A1.
Put this in B1: =LEFT(TRIM(A1),SEARCH(" ",TRIM(A1))-1) put this in C1: =MID(TRIM(A1),SEARCH(" ",TRIM(A1))+1,255) if you want real numbers (not strings), use these: Put this in B1: =--LEFT(TRIM(A1),SEARCH(" ",TRIM(A1))-1) put this in C1: =--MID(TRIM(A1),SEARCH(" ",TRIM(A1))+1,255) saziz wrote: Hi Group, I have few sheets with col containing data " 123 4567" I want this to be split in 2 dif col where space occurs. sometimes there are 4 digits in first set like "1234 5678" Any help would be apprecited. Thanks Saziz -- saziz ------------------------------------------------------------------------ saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350 View this thread: http://www.excelforum.com/showthread...hreadid=570887 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Col. split
Both the solutins worked. Thank you Saziz -- saziz ------------------------------------------------------------------------ saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350 View this thread: http://www.excelforum.com/showthread...hreadid=570887 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split | Excel Discussion (Misc queries) | |||
| How do I remove split a split window? | New Users to Excel | |||
| split bar | Charts and Charting in Excel | |||
| split? | Excel Programming | |||
| h2 (30), c1(33)--split- c1(30) -d1(3) | Excel Programming | |||
![saziz[_80_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
