Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function on "Text to Columns"
I have list of Names for e.g.
Antony, John - 30022275 David, Joan - 30022277 When I used "Text to Columns" function I am able to saparate Names in different cells but unable to saparate "Joan - 30022277" I tried even removing " - " but did not worked, is their any function so that I can saparate all for e.g. A1 - Antony B1 - John C1 - 30022275 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function on "Text to Columns"
I was able to separate Antony, John - 30022275 in to three cells using Data
| Test-to-Column I used the Delimited options and specified: comma, space, other {in which I entered the hyphen}, and Treat consecutive delimiters as one best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Nandeesh" wrote in message ... I have list of Names for e.g. Antony, John - 30022275 David, Joan - 30022277 When I used "Text to Columns" function I am able to saparate Names in different cells but unable to saparate "Joan - 30022277" I tried even removing " - " but did not worked, is their any function so that I can saparate all for e.g. A1 - Antony B1 - John C1 - 30022275 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function on "Text to Columns"
Hi
You need to select two delemiters in this case, comma and in others type "-". Hopes this helps. Per "Nandeesh" skrev i meddelelsen ... I have list of Names for e.g. Antony, John - 30022275 David, Joan - 30022277 When I used "Text to Columns" function I am able to saparate Names in different cells but unable to saparate "Joan - 30022277" I tried even removing " - " but did not worked, is their any function so that I can saparate all for e.g. A1 - Antony B1 - John C1 - 30022275 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function on "Text to Columns"
You just have to identify all your delimiters. Make sure that Comma is
checked, and under Other, enter the hyphen (-). Regards, Fred. "Nandeesh" wrote in message ... I have list of Names for e.g. Antony, John - 30022275 David, Joan - 30022277 When I used "Text to Columns" function I am able to saparate Names in different cells but unable to saparate "Joan - 30022277" I tried even removing " - " but did not worked, is their any function so that I can saparate all for e.g. A1 - Antony B1 - John C1 - 30022275 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function on "Text to Columns"
Nandeesh wrote:
I have list of Names for e.g. Antony, John - 30022275 David, Joan - 30022277 When I used "Text to Columns" function I am able to saparate Names in different cells but unable to saparate "Joan - 30022277" I tried even removing " - " but did not worked, is their any function so that I can saparate all for e.g. A1 - Antony B1 - John C1 - 30022275 Using "Text to Columns", select "Delimited" and "Next". Then check "Space", "Comma" and "Treat consecutive delimiters as one" and then click "Next". In the next dialog box, select the third column (with the hyphen "-" in it) and select the Column data format "Do not import column (skip)". Click "Finish". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
disabling default "text to columns" while *.csv file opening | Setting up and Configuration of Excel | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel should support a proper inverse to "Text to columns" | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |