| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Connecting formulas
I need to clean the periods from the first column and the first 6 characters
of the new data. In otherwords, I need column B to come from column A. PR.44.CC.106 PR44CC I can use the Left function and I can use the REPLACE function but I need to use them in one formula (mega-formula?) if possible. Many thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Connecting cells from two pages | Excel Discussion (Misc queries) | |||
| connecting to MYSQL | New Users to Excel | |||
| Connecting ballons | Excel Discussion (Misc queries) | |||
| Connecting Worksheets | Excel Discussion (Misc queries) | |||
| connecting to databases | Excel Discussion (Misc queries) | |||
Threaded Mode
