Home |
Search |
Today's Posts |
#1
|
|||
|
|||
moving data within a column
I have an old EXCEL spreadsheet with the first column containing numbers ie:
(2) 04-410, what I need to do is create a fromula to move the (2) the number in parathensis to the right side of the column . this is so I can sort. Thank you, K. Tremblay |
#2
|
|||
|
|||
Hi
one way: use 'Data - Text to columns -- Regards Frank Kabel Frankfurt, Germany "Kathy" schrieb im Newsbeitrag ... I have an old EXCEL spreadsheet with the first column containing numbers ie: (2) 04-410, what I need to do is create a fromula to move the (2) the number in parathensis to the right side of the column . this is so I can sort. Thank you, K. Tremblay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
getting data from 2 excel sheets automatically | Excel Worksheet Functions |