Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Standard Edit to Multiple Cells
I am looking to use Excel in track printing in our office. I am able to get
all the info needed exported into a spreadsheet, but I have one remaining glitch when I need to sort the information. The project number column includes the full path to the project folder on our server so there is no way to sort by project. But, there is the same number of characters before the project number for every entry. Is there a way to create a macro or a function that our billing person can easily apply to the cells in the column that says " delete the first 14 characters in this cell" or "ignore the first 14 characters when reading this cell"? Any advice would be appreciated. Thank you and Happy New Year. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Standard Edit to Multiple Cells
With data starting in A1, try this in B1:
=RIGHT(A1,LEN(A1)-14) And copy down as needed. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "jwksu" wrote in message ... I am looking to use Excel in track printing in our office. I am able to get all the info needed exported into a spreadsheet, but I have one remaining glitch when I need to sort the information. The project number column includes the full path to the project folder on our server so there is no way to sort by project. But, there is the same number of characters before the project number for every entry. Is there a way to create a macro or a function that our billing person can easily apply to the cells in the column that says " delete the first 14 characters in this cell" or "ignore the first 14 characters when reading this cell"? Any advice would be appreciated. Thank you and Happy New Year. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Standard Edit to Multiple Cells
And, with a single function call:
=MID(A1,15,255) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "RagDyeR" wrote in message ... With data starting in A1, try this in B1: =RIGHT(A1,LEN(A1)-14) And copy down as needed. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "jwksu" wrote in message ... I am looking to use Excel in track printing in our office. I am able to get all the info needed exported into a spreadsheet, but I have one remaining glitch when I need to sort the information. The project number column includes the full path to the project folder on our server so there is no way to sort by project. But, there is the same number of characters before the project number for every entry. Is there a way to create a macro or a function that our billing person can easily apply to the cells in the column that says " delete the first 14 characters in this cell" or "ignore the first 14 characters when reading this cell"? Any advice would be appreciated. Thank you and Happy New Year. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Standard Edit to Multiple Cells
Thanks. That did it.
"RagDyeR" wrote: With data starting in A1, try this in B1: =RIGHT(A1,LEN(A1)-14) And copy down as needed. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "jwksu" wrote in message ... I am looking to use Excel in track printing in our office. I am able to get all the info needed exported into a spreadsheet, but I have one remaining glitch when I need to sort the information. The project number column includes the full path to the project folder on our server so there is no way to sort by project. But, there is the same number of characters before the project number for every entry. Is there a way to create a macro or a function that our billing person can easily apply to the cells in the column that says " delete the first 14 characters in this cell" or "ignore the first 14 characters when reading this cell"? Any advice would be appreciated. Thank you and Happy New Year. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Standard Edit to Multiple Cells
Appreciate your feed-back ... BUT ... read my post to your *same* question
in the functions group. -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "jwksu" wrote in message ... Thanks. That did it. "RagDyeR" wrote: With data starting in A1, try this in B1: =RIGHT(A1,LEN(A1)-14) And copy down as needed. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "jwksu" wrote in message ... I am looking to use Excel in track printing in our office. I am able to get all the info needed exported into a spreadsheet, but I have one remaining glitch when I need to sort the information. The project number column includes the full path to the project folder on our server so there is no way to sort by project. But, there is the same number of characters before the project number for every entry. Is there a way to create a macro or a function that our billing person can easily apply to the cells in the column that says " delete the first 14 characters in this cell" or "ignore the first 14 characters when reading this cell"? Any advice would be appreciated. Thank you and Happy New Year. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to use right-click on cells; standard and formatting toolbars disabled | Excel Discussion (Misc queries) | |||
Standard deviation of specific cells in a column | Excel Discussion (Misc queries) | |||
Can I create Multiple passwords to edit multiple ranges? | Excel Discussion (Misc queries) | |||
Can a standard data entry form be used to change formats of cells? | Excel Discussion (Misc queries) | |||
how do you find the SD(standard deviation ) for the multiple reg | Excel Worksheet Functions |