Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I separate items from one cell into two?
-- bootsy |
#2
|
|||
|
|||
here's two ideas
1) use data / text to columns 2) use a formula such as =LEFT(A1,3) or =RIGHT(A1,4) if you'ld like more assistance please post back with additional details and type out two or three examples of your data. Cheers JulieD "Bootsy" wrote in message ... -- bootsy |
#3
|
|||
|
|||
|
#4
|
|||
|
|||
Peo Sjoblom wrote:
<NOTHING! http://dts-l.org/goodpost.htm http://www.netmeister.org/news/learn2quote.html -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk |
#5
|
|||
|
|||
This is Peo's way of answering posts that have the question in the subject (and
nothing in the body). Peo "Mahatma" Sjoblom Master of civil disobedience. (He dislikes it at least as much as you.) Gordon wrote: Peo Sjoblom wrote: <NOTHING! http://dts-l.org/goodpost.htm http://www.netmeister.org/news/learn2quote.html -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk -- Dave Peterson |
#6
|
|||
|
|||
Dave Peterson wrote:
This is Peo's way of answering posts that have the question in the subject (and nothing in the body). Peo "Mahatma" Sjoblom Master of civil disobedience. (He dislikes it at least as much as you.) But perpetuating the "crime" is not a solution, especially when he doesn't point out to the OP the error of his ways! -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |