Excel help

ptonsparky

Senior Member
I have a series of names and Job #s I would like to separate via Excel. Data is in this format.

Customer, Name: 20087 Job description.

I want to separte the data at the : and move one side or the other to a different cell.

What function do I use?
 

GeorgeB

ElectroHydraulics engineer (retired)
It may be different with different versions, but in general. select the column; data; text to column
 

hbiss

EC, Westchester, New York NEC: 2014
Have you ever played with Microsoft Access? It has the same look and feel as Excel except it is a relational data base. You're all set up actually because you already have unique customer numbers. Just put customer and job description after it in separate columns and you can sort it any way you want.

-Hal
 

gadfly56

Senior Member
Play around with a copy of your data and the "DATA" tab in Excel. Must be a hundred ways to import into Excel.
 

Hv&Lv

Senior Member
I have a series of names and Job #s I would like to separate via Excel. Data is in this format.

Customer, Name: 20087 Job description.

I want to separte the data at the : and move one side or the other to a different cell.

What function do I use?
Is it all in one cell now? Is it a .csv file?
if it’s all in one cell go to data tab, then click on text to column.
when the wizard comes up, click delimited, then next.
colon isnt an option, so check the box Labeled “other” and type a colon in the box.
check them all it will separate all the items. The preview will show what it will look like.
if you like it, click next, and then finish..
 
Last edited:

ptonsparky

Senior Member
Play around with a copy of your data and the "DATA" tab in Excel. Must be a hundred ways to import into Excel.
Yes there is. I’m struggling at home to get data from the Main Office computer. Long story. Between weather, intermittent internet, 365 and Office 10, I’m ready to isolate at the shop vs home.
 

Dennis Alwon

Moderator
Staff member
It is easy with text to column under data as stated earlier. Highlight the column --select data-text to column- delimited- then check semicolon and other. In the other box type a semicolon. This will separate the cell into 2 cells and eliminate the semicolon which I assume you don't need. The semicolon works on a colon
 

ATSman

Senior Member
Not sure what you want on the page but I was going to use Excel for my company Work In Progress job record to show all labor and expenses, job status, job description, date invoiced, date paid and could not include all the info on an Excel page. So I used the Table app in MS Word and found it worked well after I tweaked it over the years. It became a very valuable file that I updated thru the year and then summarized the info to give to my tax guy every year.
One drawback is you have to manually add the numbers in the columns to get totals on each page.
I had trouble attaching a sample page. Let me know if you want to see the page and will try in another way.
 
Last edited:

ptonsparky

Senior Member
It is easy with text to column under data as stated earlier. Highlight the column --select data-text to column- delimited- then check semicolon and other. In the other box type a semicolon. This will separate the cell into 2 cells and eliminate the semicolon which I assume you don't need. The semicolon works on a colon
I missed a step in there earlier and I have all day tomorrow...
 

zbang

Senior Member
Maybe won't help here, but there have been times I took a csv out of excel, edited in my handy text editor (not word processor), then imported back to excel. It's a snap to do things like turn " Name: " into ",".
 

ptonsparky

Senior Member
It may be different with different versions, but in general. select the column; data; text to column
It is easy with text to column under data as stated earlier. Highlight the column --select data-text to column- delimited- then check semicolon and other. In the other box type a semicolon. This will separate the cell into 2 cells and eliminate the semicolon which I assume you don't need. The semicolon works on a colon
Worked. Thanks.


PWBCAK











Problem Was Between Chair And Keyboard
 

Dennis Alwon

Moderator
Staff member
Glad I could help....Smart$ was great at things like this. I miss his input. I just googled it and got close- had to figure out the part with "other"
 
Top