If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
6 numbers in one column
6 numbers in one column separated by hyphen. want to put them in separate columns
|
#2
|
|||
|
|||
6 numbers in one column
Try...
Data|Text to Columns with hyphen as delimiter. "Edo" wrote in message ... 6 numbers in one column separated by hyphen. want to put them in separate columns |
#3
|
|||
|
|||
6 numbers in one column
Hi Edo,
Try using Text to Columns, 1) Select your data 2) Data Text to Columns 3) Choose Delimited as your Data Type 4) Click Next 5) Check Other as your delimiter and type the hyphen into the box next to it 6) Click OK/Finish Hope this helps! In article , Edo wrote: 6 numbers in one column separated by hyphen. want to put them in separate columns |
#4
|
|||
|
|||
6 numbers in one column
Edo,
Try DataText to Columns. HTH Anders Silven "Edo" skrev i meddelandet ... 6 numbers in one column separated by hyphen. want to put them in separate columns |
#5
|
|||
|
|||
6 numbers in one column
Choose Data/Text to Columns. Select the Delimited radio button. Click
next. Check the Other checkbox and insert a hyphen in the textbox. Click Finish. In article , Edo wrote: 6 numbers in one column separated by hyphen. want to put them in separate columns |
#6
|
|||
|
|||
6 numbers in one column
Thanx I had to do some juggling around, but it worked
"Aladin Akyurek" wrote: Try... Data|Text to Columns with hyphen as delimiter. "Edo" wrote in message ... 6 numbers in one column separated by hyphen. want to put them in separate columns |
#7
|
|||
|
|||
6 numbers in one column
Thanx I had to do some juggling around, but it worked
"Anders Silven" wrote: Edo, Try DataText to Columns. HTH Anders Silven "Edo" skrev i meddelandet ... 6 numbers in one column separated by hyphen. want to put them in separate columns |
#8
|
|||
|
|||
6 numbers in one column
Thanx I had to do some juggling around, but it worked
"JE McGimpsey" wrote: Choose Data/Text to Columns. Select the Delimited radio button. Click next. Check the Other checkbox and insert a hyphen in the textbox. Click Finish. In article , Edo wrote: 6 numbers in one column separated by hyphen. want to put them in separate columns |
#9
|
|||
|
|||
6 numbers in one column
Thanx I had to do some juggling around, but it worked
"Domenic" wrote: Hi Edo, Try using Text to Columns, 1) Select your data 2) Data Text to Columns 3) Choose Delimited as your Data Type 4) Click Next 5) Check Other as your delimiter and type the hyphen into the box next to it 6) Click OK/Finish Hope this helps! In article , Edo wrote: 6 numbers in one column separated by hyphen. want to put them in separate columns |
Thread Tools | |
Display Modes | |
|
|