| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Seperatin data ffom one column into another column
Is there an easy way to extract data from one column and put it into another
column on the same row. I have a large file where for example in column A, a large number of the records have (some sort of text) along with the main data. I would like to extract all the (some sort of text) c/w brackets from column A and put it into column B -- Regards Michael Koerner |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Seperatin data ffom one column into another column
Data/Text to Columns...
In article , "Michael Koerner" wrote: Is there an easy way to extract data from one column and put it into another column on the same row. I have a large file where for example in column A, a large number of the records have (some sort of text) along with the main data. I would like to extract all the (some sort of text) c/w brackets from column A and put it into column B |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Seperatin data ffom one column into another column
Thank you very much.
-- Regards Michael Koerner "J.E. McGimpsey" wrote in message ... Data/Text to Columns... In article , "Michael Koerner" wrote: Is there an easy way to extract data from one column and put it into another column on the same row. I have a large file where for example in column A, a large number of the records have (some sort of text) along with the main data. I would like to extract all the (some sort of text) c/w brackets from column A and put it into column B |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FInd common data in one column then add number in adjacent column | Excel Worksheet Functions | |||
| Plotting multiple Y column data versus single X column in Excel 20 | Charts and Charting in Excel | |||
| Count cells w/values in column if the data in column a matches cri | Excel Worksheet Functions | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
Linear Mode
