| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
POPULATE CELL WITH CHARACTERS FROM ANOTHER CELL
The cell A has a catalog number in it with the order it belongs in the mix.
What I need to do is seperate the catalog number from the order number is there a function or macro that will do this? Thanks in advance for the help. A B C A2399(1) A2399 1 A2418(2) A2418 2 A3625(10) A3625 10 A8697(8) A8697 8 A5867(11) A5867 11 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
POPULATE CELL WITH CHARACTERS FROM ANOTHER CELL
Paste this in colum B
=LEFT(A1,FIND("(",A1)-1) Paste this in column C =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1) "Daniell" wrote: The cell A has a catalog number in it with the order it belongs in the mix. What I need to do is seperate the catalog number from the order number is there a function or macro that will do this? Thanks in advance for the help. A B C A2399(1) A2399 1 A2418(2) A2418 2 A3625(10) A3625 10 A8697(8) A8697 8 A5867(11) A5867 11 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
POPULATE CELL WITH CHARACTERS FROM ANOTHER CELL
Another way:
Copy column A to columns B and C (3 columns that look identical) Select column B edit|replace what: (* with: (leave blank) replace all Select column C Edit|Replace what: *( with: (Leave blank) replace all and one more edit|replace what: ) with: (leave blank) replace all If you really need a macro, you could record one when you do it manually. Daniell wrote: The cell A has a catalog number in it with the order it belongs in the mix. What I need to do is seperate the catalog number from the order number is there a function or macro that will do this? Thanks in advance for the help. A B C A2399(1) A2399 1 A2418(2) A2418 2 A3625(10) A3625 10 A8697(8) A8697 8 A5867(11) A5867 11 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
POPULATE CELL WITH CHARACTERS FROM ANOTHER CELL
Thanks for the help
"Dave Peterson" wrote: Another way: Copy column A to columns B and C (3 columns that look identical) Select column B edit|replace what: (* with: (leave blank) replace all Select column C Edit|Replace what: *( with: (Leave blank) replace all and one more edit|replace what: ) with: (leave blank) replace all If you really need a macro, you could record one when you do it manually. Daniell wrote: The cell A has a catalog number in it with the order it belongs in the mix. What I need to do is seperate the catalog number from the order number is there a function or macro that will do this? Thanks in advance for the help. A B C A2399(1) A2399 1 A2418(2) A2418 2 A3625(10) A3625 10 A8697(8) A8697 8 A5867(11) A5867 11 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populate cell is another cell is populated | Excel Discussion (Misc queries) | |||
| Skip cell if X nonexistent, populate next cell | Excel Discussion (Misc queries) | |||
| auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
| How can I populate an Excel cell based on the data in another cell | Excel Worksheet Functions | |||
| make a cell automatically populate with "1" when specified cell va | Excel Discussion (Misc queries) | |||
Linear Mode
